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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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:
 
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:
 
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
 
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
 
Back
Top