How do you use the datedif function in Microsoft Excel?

DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates.

Syntax for DATEDIF: =DATEDIF(Date1, Date2, Interval)

Date1 = first date

Date2 = second date

Interval = interval type

Interval Types:

m = Months (complete calendar months between dates)

d = Days (number of days between dates)

y = Years (complete calendar years between dates)

ym = Months Excluding Years (complete calendar months between dates like they were in the same year)

yd = Days Excluding Years (complete calendar days between dates like they were in the same year)

MD = Days Excluding Years And Months (complete calendar days between dates like they were in the same month and same year)