Increase date by 1 year

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

In Excel 2003, how can I build a formula to increase each subsequent date in
a column by one year (not 365 days) when the first date in the column is
changeable.

Thanks...jcs
 
Assuming your changeable date is in A1, enter this formula in A2:

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

Copy down as far as needed.

HTH,
Elkar
 
What if the beginning column format date is 8/1/07 where the year, month and
day are not segregated?
 
If it is real Excel date, then Excel will find yy, mm and dd no matter what
format is used.
Did you try it?
 
Actually it worked based on your original suggestion
(=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)
). Sorry I must have entered the formula incorrectly at first. This was a
great and simple solution. Thanks again...jcs
 
Back
Top