Advancing the year
"JT" wrote:
I have a date in C3 (October 12, 2009) and would like cell d3 to display
that
same day, but 3 years later (October 12, 2012). Is there a formula that I
can use to make that happen?
Ostensibly:
=DATE(3+YEAR(C3),MONTH(C3),DAY(C3))
But beware of Feb 29 in leap years. A better solution might be:
=EDATE(C3,12*3)
If you get a #NAME error, see the EDATE help page. If you cannot load the
Analysis ToolPak, then try:
=DATE(3+YEAR(C3),1+MONTH(C3),0)
|