View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Becks Becks is offline
external usenet poster
 
Posts: 13
Default Anniversary of a date

Hi - I need a formula that will return the date of this years anniversary of
a date in the past. My data is set out as follows:

a b c
1 B Smith 25/10/02 25/10/07

B1 is the orignal start date, so i need C1 to show the date of this years
anniversary. Can anyone help?

Regards

Becks