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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date function 1
Excel Is this possible?? 3
is OFFSET the functcion for me? 2
Excel formula to incrementally increase a value by 1 every 365 day 2
How to enter excel dates for last year? 10
Need help creating a simple (?) SUM formula! 4
CALENDAR CREATION 1
I need help to make a not-so-easy AVERAGE formula! 4

Back
Top