Need date to advance 1 month

July 28, 2011 at 12:45:40
Specs: Windows XP
In Excel I'm trying to auto-populate date to one month from the date above i.e. 1/1/11, 2/1/11, 3/1/11. Need a formula so all I have to do is change the 1st number and each cell below will populate.

See More: Need date to advance 1 month

Report •

July 28, 2011 at 12:52:19
=date(year(A1),Month(A1)+1,Day(A1)) is one way of doing it assuming the first date is in A1

another would be:


Where 1 would need to be changed to the day of the month you start with.

Be advized you will get odd results if you use 29th to 31st day of a month since not all months have these days.

Report •
Related Solutions

Ask Question