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
|
|
|
|