Formula for Repeating the Same Date Each Year

[Guest]

Hi,
The subject title says it all really...does anyone know how I can use a
formula in Excel to repeat the same date each year, allowing for leap years?

e.g. if the value in cell C1 is 28/2/07, I want the formula to automatically
put 28/2/08 in cell D1.

I know I could just use C1+365 but that wouldn't account for the extra day
in a leap year.

Any suggestions?

 

[Guest]

D1: =DATE(YEAR(C1)+1,MONTH(C1),DAY(C1))

 

[Guest]

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

With your starting date in A1 enter this in A2 and drag right as far as you
want

 

[Guest]

sorry I meant put it in B1 and drag right

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

With your starting date in A1 enter this in A2 and drag right as far as you
want

 

[Guest]

Ignore the previous reply. Here is the correct formula

=EOMONTH(C1,12)

Required Analysis Toolpak Add Ins

 

[Guest]

Mike / 'Mama',

Thanks both for your responses, took me a moment to work out that EOMONTH
stands for end of month, so won't work for dates other than the last day of
the month, but both will be useful.

Dickie

 

[Dana DeLouis]

Hi. The usual question is if the date is 2/29/2008, what do you want 1 year
in the future to be?

Another option might be:
=EDATE(A1,12)