adding the years...

  • Thread starter Roman Abramovich
  • Start date
R

Roman Abramovich

I have a cell linked to a cell with a start-date, say 01/01/2005, and below this I want to add one year at a time to create a series.

01/01/2005 (+365)
01/01/2006 (+365)
01/01/2007

Though of course, this will be thrown out by pesky leap years. Any easier way?

Thanks
 
K

kkknie

Try this formula:

=DATE(YEAR(H7)+1,MONTH(H7),DAY(H7))

Where H7 is the initial year.

K
 
Top