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

"Becks" <(E-Mail Removed)> wrote in message news:35F7E891-6D8E-4CEC-A04E-(E-Mail Removed)...
| 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

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" <(E-Mail Removed)> wrote in message news:35F7E891-6D8E-4CEC-A04E-(E-Mail Removed)...
> | 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


"Becks" <(E-Mail Removed)> wrote in message news:4BC153A7-92CF-4B1E-B1BF-(E-Mail Removed)...
| 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" <(E-Mail Removed)> wrote in message news:35F7E891-6D8E-4CEC-A04E-(E-Mail Removed)...
| > | 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
| >
| >
| >

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" <(E-Mail Removed)> wrote in message news:4BC153A7-92CF-4B1E-B1BF-(E-Mail Removed)...
> | 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" <(E-Mail Removed)> wrote in message news:35F7E891-6D8E-4CEC-A04E-(E-Mail Removed)...
> | > | 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
> | >
> | >
> | >
>
>
>