DATEDIF function in Excel

Syntax

=DATEDIF(start_date, end_date, unit)

Example

=DATEDIF(B2,C2,"Y") returns the whole years between the two dates.

From the lesson DATEDIF Function.

Common mistakes

• Putting the end date first (you get #NUM!).
• Forgetting the unit text needs quotes.

Related date functions

• DATEBuilds a date from year, month and day.
• TODAYReturns today's date.
• DAYSNumber of days between two dates.
• EDATEDate a number of months before or after.
• EOMONTHLast day of the month, months away.
• WORKDAYDate a number of working days away.
• YEARReturns the year of a date.
• MONTHReturns the month of a date.