How do I calculate exact difference between two dates in y,m,d.

  • Thread starter Muhammad Javaid Hassan
  • Start date
M

Muhammad Javaid Hassan

I want to calculate the difference between two dates exactly in years, months
and days. Say between the dates 14-02-1980 to 28-02-1985. The difference is 5
years, 0 months and 14 days including both the starting and ending dates. But
excel does not give the exact answer. Pl help me.
 
M

Marcelo

Hi Muhammad,

use the datedif function

=datedif(initial_date,final_date,"X")

X is
"Y" to see the diference in years
"M" to see the diference in months
"D" to see the diference in days
"MD" to see the diference but, months and years are ignorated
"YD" to see the diference but, days and years are ignorated

hth



--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Muhammad Javaid Hassan" escreveu:
 
D

Domenic

Assuming that A2 contains the first date, and B2 contains the second,
try...

=DATEDIF(A2,B2,"y")

=DATEDIF(A2,B2,"ym")

=DATEDIF(A2,B2,"yd")

Hope this helps!

Muhammad Javaid Hassan <Muhammad Javaid
 

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

How to use/create code in MS Word to calculate age? 0
Calculating the difference, in hours, between two date/time in two different time zon 2
How do I calculate exact difference between two dates in y,m,d. 8
Difference between two date/time values 6
How to calculate difference between two date & time along with working hours and days 2
How do I calculate the difference between 2 dates (m,d,y) ? 8
How to calculate diffrence between two dates 2
How calculate exact # of months between two dates? 9

Top