how to creat a formula to advance date by one year
 

I need help in creating a formula to advance date by a year for my files (too
many to change manually)

Thanks Liz

how to creat a formula to advance date by one year
 

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

how to creat a formula to advance date by one year
 

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

how to creat a formula to advance date by one year
 

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

copy down as far as needed


"Liz Lalman" wrote:

I need help in creating a formula to advance date by a year for my files (too
many to change manually)

Thanks Liz