Increase date by 1 year

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
 
G

Guest

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
 
C

Craig

What if the beginning column format date is 8/1/07 where the year, month and
day are not segregated?
 
B

Bernard Liengme

If it is real Excel date, then Excel will find yy, mm and dd no matter what
format is used.
Did you try it?
 
C

Craig

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 formula to incrementally increase a value by 1 every 365 day 2
How to enter excel dates for last year? 10
conditional format cells by date 2
Date Formula 6
Remove date format? 3
Need help creating a simple (?) SUM formula! 4
Calculate next year in different cell 10

Top