View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default Excel 2002 automated annual date change

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