| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Anniversary of a date
Brilliant, thanks very much.
"Niek Otten" wrote: Yes, it will update because TODAY() updates (a volatile function) -- Kind regards, Niek Otten Microsoft MVP - Excel "Becks" wrote in message ... | Thanks for that Niek. Will this update it's self when we enter a new year? | | "Niek Otten" wrote: | | =DATE(YEAR(TODAY()),MONTH(B1),DAY(B1)) | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Becks" wrote in message ... | | 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 | | | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Days to next anniversary | Excel Discussion (Misc queries) | |||
| formula to display anniversary date | Excel Worksheet Functions | |||
| Calculating Anniversary | Excel Discussion (Misc queries) | |||
| calculate anniversary of date after specified date | Excel Worksheet Functions | |||
| How do I get an anniversary date? | Excel Worksheet Functions | |||
Threaded Mode
