NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET

G

Guest

Use DATEDIF():

if A1 and A2 contain:
1/15/1985
12/31/2005

then:
=DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " &
DATEDIF(A1,A2,"md") & " days"

will display:
20 years, 11 months, 16 days
 

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

Can you calculate the number of years between two dates in Excel 0 4
calculating ages 3
count the number of months between two dates 3
Calculating number of weeks between dates? 2
How do I calculate exact difference between two dates in y,m,d. 6
Number of Weekend Days between 2 Dates Q 1
How to calculate # of days 3
HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES 2

Top