View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default Advancing the year

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?


One way:
=DATE(YEAR(C3)+3,MONTH(C3),DAY(C3))

Notice that for 02-29-08 (leap year) the result is 03-01-11.