Dear Bernard,
I have a range of dates and i need to change them
one year in advance....

eg.. Leases to renew them for another year to date.

Thanks Liz

"Bernard Liengme" wrote:

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