skip one month by one month

[Admin]

How can I skip one month by one month
A1 01/01/2005
A2 28/02/2005
A3 31/03/2005
how can I scroll to the A12 with 31/12/2005?

 

[Mangesh Yadav]

In A1 eneter 1/1/2005
A2 enter the formula:
=DATE(YEAR(A1),MONTH(A1)+2,1)-1
and drag down to copy.

Mangesh

 

[Dave Peterson]

Another one:

With Jan 1, 2005 in A1:
put this in A2 and drag down:

=DATE(YEAR(A1),MONTH(A1)+2,0)

The zeroeth day of a month is the last day of the previous month.