Site icon ExcelNotes

How to Use DATEDIF Function

The DATEDIF function is to count the number of days, months, or years between two dates.

Formula:

=DATEDIF(start_date,end_date,unit)

Explanations:

– The start_date is required, which is the first date that needs to count.

– The end_date is required, the second date needs to count.

– The unit is required, the data format you need to return. Please refer to the table below:

"Y"The number of years
"M"The number of months
"D"The number of days
"MD"The difference when ignoring the years and months
"YM"The difference when ignoring the years and days
"YD"The difference when ignoring the year

Cautions:

Dates are stored as sequential serial numbers and December 31, 1899 is serial number 1.

Example:

=DATEDIF(A2,B2,"Y")

The result returns 4. There are 4 years between the two dates.

=DATEDIF(A3,B3,"M")

The result returns 57. There are 57 months between the two dates.

=DATEDIF(A4,B4,"D")

The result returns 1761. There are 1761 days between the two dates.

Download: DATEDIF Function

Exit mobile version