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/