If you could see me I'd be bowing to you in homage..


Thank-you very much


"Chip Pearson" wrote:

The formula on the "Calculating A Person's Age" section of the
web page will return a string stating how many years, months, and
days a person has been alive.

=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & "
months, " & DATEDIF(A1,B1,"md") & " days"

where A1 is birthdate and B1 is death date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Rameris" wrote in message
...
Well I guess I am the thickest individual in the solar system
but doesn't
that tell me either how many years OR months OR days? I need
to know how
may of each for example in

"Gary''s Student" wrote:

Yes:


See:

http://www.cpearson.com/excel/datedif.htm
--
Gary''s Student


"Rameris" wrote:

I need to find out the amount of time between two dates for
filling out
funeral benefits. The form asks how long the person has
been alive in Years
Months and Days.

I would like to know if I put for instance 10/21/1955 in say
A1 as the birth
date and 01/25/2006 in B1 as the date of death. So what is
the formula, if
one, to calculate the time in years months and days that has
passed between
the two dates?