Can someone help me create a formula for calculating the difference between 2
dates:

column A: date of birth
column B: date of death
column C: time period between A and B (C1=B1-A1; C2 = A2-B2, etc.)

Thanks.
Raj

Difference of what ?
For Years: =DATEDIF(A1,B1,"Y")
For Months: =DATEDIF(A1,B1,"m")
For Days: =DATEDIF(A1,B1,"d")
Micky


"Raj" wrote:

Can someone help me create a formula for calculating the difference between 2
dates:

column A: date of birth
column B: date of death
column C: time period between A and B (C1=B1-A1; C2 = A2-B2, etc.)

Thanks.
Raj

Yes, that's right. It gives the answer in days. Format the result as number
or general, not as date.
--
David Biddulph

"Raj" <Raj @discussions.microsoft.com wrote in message
...
Can someone help me create a formula for calculating the difference
between 2
dates:

column A: date of birth
column B: date of death
column C: time period between A and B (C1=B1-A1; C2 = A2-B2, etc.)

Thanks.
Raj

Enter this formula in C1 and drag/copy down.


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


Gord Dibben MS Excel MVP


On Wed, 9 Dec 2009 08:00:01 -0800, Raj <Raj @discussions.microsoft.com
wrote:

Can someone help me create a formula for calculating the difference between 2
dates:

column A: date of birth
column B: date of death
column C: time period between A and B (C1=B1-A1; C2 = A2-B2, etc.)

Thanks.
Raj