On Mon, 30 May 2005 03:48:01 -0500, rocket0612
wrote:
I have 2 cells, A1 were a date will be input and A2 were a date of birth
will be input. I then have cell A3 were I would like it to show the
someone's age next birthday at date in the cell A1. For example:
A1 = 1 May 2005
A2 = 15 June 1950 (date of birth)
A3 = 55
so on 1 May 2005, the age next birthday of the individual is 55.
all help appreciated, thanks
=YEAR(DATE(YEAR(A1)+(A1DATE(YEAR(A1),MONTH(
A2),DAY(A2))),MONTH(A2),DAY(A2)))-YEAR(A2)
--ron
|