Formula for calculating time period between 2 dates

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
 
D

David Biddulph

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for finding Date difference between 2 dates 4
Calculating total elapsed minutes between two dates 1
calculating the number of days continuation 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula Question 2
Excel Help with dates 2
Calculate Holding Period Returns Between Two Customizable Dates 1
Difference of time 3

Top