Hi All,

I am looking for a formula to do the following.

I have a cell that has a date in it. Example: 09/15/2006
I have a person I want to be specific age. Example: 12 years old
I have the person's birth Month and Year: Example 12/31

I want to calculate the persons birthday as of the value of cell 1
(09/15/2006) using the specific age and birth Month and Year. In the example
the result would be 12/31/1993.

Any help would be appreciated,

Jill

So my formula on 09/15/2006 a 12 year old born on 12/31 should have a
birthday of 12/31/

If I understand you correctly and assuming that you have 12/31 in cell (in
my example B1), formatted as m/d and the date 09/15/06 in A1 try:

=DATE(YEAR(A1)-12-(DATE(YEAR(A1),MONTH(B1),DAY(B1))>A1),MONTH(B1),DAY(B1))


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
(E-Mail Removed) with @tiscali.co.uk


"WiVikeFan" <(E-Mail Removed)> wrote in message
news:227AFE25-96EB-48F9-8447-(E-Mail Removed)...
> Hi All,
>
> I am looking for a formula to do the following.
>
> I have a cell that has a date in it. Example: 09/15/2006
> I have a person I want to be specific age. Example: 12 years old
> I have the person's birth Month and Year: Example 12/31
>
> I want to calculate the persons birthday as of the value of cell 1
> (09/15/2006) using the specific age and birth Month and Year. In the
> example
> the result would be 12/31/1993.
>
> Any help would be appreciated,
>
> Jill
>
> So my formula on 09/15/2006 a 12 year old born on 12/31 should have a
> birthday of 12/31/