Date Function
 

I am trying to enter an date in cell A2 (i.e. 12/31/04)
I want the date for the last day of the next month to automatically appear
in cell A33 (1/31/05), the last day of the next month to appear in cell A34
(2/28/05), and to continue this pattern for the next 60 months.
If I change the date in cell A2 (i.e. 2/28/05), I would like all the dates
in A33, A34 etc to automatically update (A33 would become 3/31/05, A34 would
become 4/30/05, etc etc).
I tried using the format =DATE(Year(A2),MONTH(A2+1),DAY(A2)), but that gives
me 1/31/04 in Cell A33 (it doesn't update the year)
Any suggestions?

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

Regards,

Peo Sjoblom

"drschieff" wrote:

I am trying to enter an date in cell A2 (i.e. 12/31/04)
I want the date for the last day of the next month to automatically appear
in cell A33 (1/31/05), the last day of the next month to appear in cell A34
(2/28/05), and to continue this pattern for the next 60 months.
If I change the date in cell A2 (i.e. 2/28/05), I would like all the dates
in A33, A34 etc to automatically update (A33 would become 3/31/05, A34 would
become 4/30/05, etc etc).
I tried using the format =DATE(Year(A2),MONTH(A2+1),DAY(A2)), but that gives
me 1/31/04 in Cell A33 (it doesn't update the year)
Any suggestions?