Formula for forward looking leap year date

[rlc]

I have several dates that require me to be forward looking and I need to ensure it accounts for leap year. The example is
A B C
Year: 12/19/2012 Years after: 20 Existing Formula: =A(B*365) , Result is 12/14/2032 I am not sure this addresses leap year. Any assistance is appreciated

 

[rlc]

My Example did not post correctly.

A. Year: 12/19/2012
B. Forward number of years: 20
C. Existing Formula: =12/19/2012(20*365)
D. Current result: 12/14/2032

 

[Jonmo1]

You're right, that won't account for leap years.

Try
=EDATE(A1,B1*12)

This requires the analysis toolpack
In XL2007+ it's installed by default
In XL2003 you have to add it from Tools - Addins.

 

[rlc]

Thanks, it works, can you briefly elaborate on the "*12" Portion of the formula? It is representing months? and why 12 vs 365. Just trying to understand a little better
Thanks again

 

[Jonmo1]

Glad to help.

The edate function creates a date that is the specified number of Months from the original date.
So it requires an input of MONTHS, not DAYS.
So 12 months in a Year, 20 years = 20*12 Months

 

[rlc]

Jonmo1, you really are an Excel MVP, thanks for clearing this up for me.