Hi Roar,

Thanks for the input but I actually need it in one cell and for that cell to
automatically update on the anniversary of the date. Sort of like a TODAY
function works, but not daily, only annually. I think what you're referring
to would work as a copying action. I'm not even sure what I need to do can
be done in Excel. Hopefully, I'm wrong.

Thanks,
--
Cheryl


"Roar" wrote:

Cheryl,

Write the first 2 years dates in the worksheet. Mark those 2 cells, and drag
it all down or to the left. Then the annuals will be updated.
--
Cheryl skrev:

I need to know if there is anyway to update a date annually, not daily. In
other words, say today is 8/20/06. I need the date to be updated
automatically on 8/20/07, 8/20/08, etc. It would need to be entered into one
cell because I need to use it in a calculation.
--
Thanks,
Cheryl