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?

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?

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?

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?

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?

I hope you don't mind answering another question but I used the same basic
formula with two different dates.

The results were correct as I now have

XX Years XX months and XX days for a calculation of a person's age

YY years YY months and YY days for a calculation of a person's time with the
company

When I tried to add those two numbers by simply putting for example
@sum(d4+d5) I got a # VALUE error

The reason I wanted to add those two was a person can retire from our
company when a combination of their age and years of service hit 80 combined
total.

Can you explain what I'm doing wrong in that case?

"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?

You are trying to add two strings of text, so you get the #VALUE error.

Pete