Anniversary of a date
 

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

Anniversary of a date
 

=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

Anniversary of a date
 

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

Anniversary of a date
 

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

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