Increase date by 1 year
 

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

Increase date by 1 year
 

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Craig" wrote in message
. ..
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

Increase date by 1 year
 

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


"Craig" wrote:

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

Increase date by 1 year
 

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

"Bernard Liengme" wrote in message
...
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Craig" wrote in message
. ..
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

Increase date by 1 year
 

If it is real Excel date, then Excel will find yy, mm and dd no matter what
format is used.
Did you try it?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Craig" wrote in message
. ..
What if the beginning column format date is 8/1/07 where the year, month
and day are not segregated?

"Bernard Liengme" wrote in message
...
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Craig" wrote in message
. ..
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

Increase date by 1 year
 

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

"Bernard Liengme" wrote in message
...
If it is real Excel date, then Excel will find yy, mm and dd no matter
what format is used.
Did you try it?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Craig" wrote in message
. ..
What if the beginning column format date is 8/1/07 where the year, month
and day are not segregated?

"Bernard Liengme" wrote in message
...
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Craig" wrote in message
. ..
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