Add a month ??

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

In cell A1 I have 01/01/04. What formula could I use in A2
and fill down the A column to show 02/01/04, 03/01/04,
04/01/04 etc. ??

Thanks.......Will
 
Will,

If you type the dates in A1 and A2, then select both cells, and
drag-and-copy, Excel will automatically work it out.

If you must have a formula, in A2
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)
and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
In cell A1 I have 01/01/04. What formula could I use in A2
and fill down the A column to show 02/01/04, 03/01/04,
04/01/04 etc. ??

Thanks.......Will
Click to expand...

If the day of the month is A1 is <29, then:

A2: = A1 + DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))

If it can be >28, then post back and let us know what you want to do in that
event.



--ron
 
Or type in 1/1/2004 and copy down using the right mouse button,
when you release the button you get a lot of options where one is fill down
months
 
Will said:
In cell A1 I have 01/01/04. What formula could I use in A2
and fill down the A column to show 02/01/04, 03/01/04,
04/01/04 etc. ??

Thanks.......Will
Click to expand...

In A2
=EDATE(A1,1) ; fill down

This requires the analysis tool pak
 
In A2:

=DATE(Year(A1),month(A1)+1, 1)

In A3:

=DATE(Year(A2),month(A2)+1, 1)

and so on.

If you want to write the month ends, if A1 is 1/31/04, then in A2:

=DATE(Year(A1),month(A1)+2, 0)

This gets the date for March 0, which Excel will show as Feb-29. By
going out for two months but for day 0 (rather than day 1) -- another
way to say this is to find the first day of two months later, then go
back 1 day -- you always get the correct ending day for the next
month.
 
Back
Top