How to calculate the difference between Dates in Excel

Here is a new post to which will help you to calculate the difference between two dates in excel.

DATEDIF:

This function calculates the difference between two dates. It can show the result in weeks, months or years.

=DATEDIF(FirstDate,SecondDate,"Interval")

First Date: This is the earliest of the two dates.
Second Date: This is the most recent of the two dates.
Interval: This indicates what you want to calculate.

These are the available intervals.

• "D" Days between the two dates.


• "M" Months between the two dates.


• "Y" Years between the two dates.


• "YD" Days between the dates, as if the dates were in the same year.


• "YM" Months between the dates, as if the dates were in the same year.


• "MD" Days between the two dates, as if the dates were in the same month and year.

Please note the Second Date must be greater than the first date, else you would end up with error

Below In The Example For The Datedif Function And Respective Syntax