Solved how to use dates in excel

April 14, 2020 at 14:29:04
Specs: Windows 10
I am trying to make a formula that uses what we call adverse date.

If a cell date is showing 05/01/2020, then I want my result to show 06/01/2020.

If a cell date is showing 04/30/2020, then in want my result to show 05/01/2020.

Results to show always need to be the first dat of the month. Then of course keep the year current.


See More: how to use dates in excel

Reply ↓  Report •

#1
April 14, 2020 at 15:12:31
✔ Best Answer
Not completely sure what your doing but try this:

With your Date in cell A1 enter the formula in B1: =EOMONTH(A1,0)+1

Also, for future reference, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question