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

VBA Coding Help for Beginner 0
Data Validation List 1
% Difference between cells based on variable... 6
countifs Function not giving desired result with date criteria 2
IF formula with certain conditions to achieve a desired value 2
Determine accuracy percentage between two dates 2
Calculating total elapsed minutes between two dates 1
Formula for finding Date difference between 2 dates 4

Top