Previous Topic Next Topic

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

Related:

1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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
kittycat
Nov 29, 2011 at 03:55 PM
Thank you!!
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response