How to adjust a function to reflect the new year change
 

I have a formula
=DATE(YEAR(B37)+F39,MONTH(B37-1),DAY(B37-1))
This is to calculate yearly contract dates, # of years and start date are
entered.

this works until I enter a date in Jan 2007, it will give me an end date of
12/2008. I neet to do an IF function to tell excel not to change the date if
Jan 07 is used.

How to adjust a function to reflect the new year change
 

Lisa,

If your date of 1/15/07 is in A1 the in another cell put:

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

This will give the year end date of 12/31/07.

CHORDially,
Art Farrell

"Lisa" wrote in message
...
I have a formula
=DATE(YEAR(B37)+F39,MONTH(B37-1),DAY(B37-1))
This is to calculate yearly contract dates, # of years and start date are
entered.

this works until I enter a date in Jan 2007, it will give me an end date
of
12/2008. I neet to do an IF function to tell excel not to change the date
if
Jan 07 is used.