Date

[Aaron]

I have a specific date (Jan 19, 2002) and I want to add three (3) years to that date to get (Jan 19, 2005). Would someone please offer a formula suggestion? Thank you -asa

 

[Aladin Akyurek]

=DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))

or

=EDATE(A2,12*3) [ requires the Analysis Toolpak ]

Aladin

 

[Mark W.]

=EDATE(A1,36)

Note: The EDATE function is a part of the Analysis ToolPak.

 

[Joe Was]

Try:

=DATE(YEAR(B12)+3,MONTH(B12),DAY(B12))

JSW

 

[Aaron]

I am sorry it took me so long to reply, but thank you all. I used the formulas you guys gave me, and forgot to post Thanks. -asa