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