skip one month by one month

  • Thread starter Thread starter Admin
  • Start date Start date
A

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?
 
In A1 eneter 1/1/2005
A2 enter the formula:
=DATE(YEAR(A1),MONTH(A1)+2,1)-1
and drag down to copy.

Mangesh
 
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.
 
Back
Top