| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
| How do I automatically calculate YTD numbers by changing a date? | Excel Worksheet Functions | |||
| Calculate Due Date | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
| Calculate date of birth in Excel | Excel Worksheet Functions | |||
Threaded Mode
