Birthday Calculations

[Guest]

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/

 

[Sandy Mann]

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 address removed)
(e-mail address removed) with @tiscali.co.uk