Formula for calculating time period between 2 dates

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

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
 
Yes, that's right. It gives the answer in days. Format the result as number
or general, not as date.
 
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
 
Back
Top