What to you want to change?
The dates in a range of cells?
A formula will not do this; a macro will.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Liz Lalman" <Liz wrote in message
...
I need help in creating a formula to advance date by a year for my files
(too
many to change manually)

Thanks Liz