Previous Topic Next Topic

Help with excel

[Solved/Closed]
Report
-
 kittycat -
Hello,

does anyone kno of a formula that will automatically input the next month. for example if I am starting with 10/28/2011 what is the formula to have the next month be 11/28/2011 then 12/28/2011. I want to set it up in a way which i just have to end the first date.

Thanks

1 reply

Answer 1 / 1
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
 488
Hi,

Try this formula (DateCell is the cell containing the first date) :

= EDATE(DateCell,1)

Regards
Report

Thank you!!
Ask a question