Help with excel

Solved/Closed
kittycat - Nov 29, 2011 at 12:15 PM
 kittycat - Nov 29, 2011 at 03:55 PM
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

aquarelle
Posts
7118
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 29, 2022
491
Nov 29, 2011 at 12:42 PM
Hi,

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

= EDATE(DateCell,1)

Regards
0
Thank you!!
0