View Single Post
  #1   Report Post  
slymeat
 
Posts: n/a
Default calculate anniversary of date after specified date

Is there a way of making a function determine the first anniversary of a
specified date after another and different specified date e.g. If I have a
date value of 05/06/2004 (5th June '04) in cell A1 and want to calculate (in
cell C3) the anniversary of that date that next follows a different date
specified in cell E8, say 01/11/05 (1st November '05)?

In the example above the answer in cell C3 should be 5/6/06 (5th June '06).

--
Andrew