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