[Datedif Excel] How to calculate date difference in Excel | Excel Date Difference

Published by Get eSolutions on

Sometimes we need to calculate difference between two dates in Excel. It’s purpose can be age calculations or anything else.

If you will search on the internet, you won’t find single combine formula to get years, months & days between dates (Ex: 14 years, 2 months, 28 days. ).

In this video you will find a single combine formula to calculate date difference easily including years, months & days. (Ex: 14 years, 2 months, 28 days. ).

getesolutions FINAL FORMULA:

=IF(DATEDIF(A6,B6,"y"),DATEDIF(A6,B6,"y")&" years","")&IF(DATEDIF(A6,B6,"ym"),", "&DATEDIF(A6,B6,"ym")&" months","")&IF(DATEDIF(A6,B6,"md"),", "&DATEDIF(A6,B6,"md")&" days","")

Leave a Reply