View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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)