Anniversary of a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=DATE(YEAR(TODAY()),MONTH(B1),DAY(B1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
 
Yes, it will update because TODAY() updates (a volatile function)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


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