DATEDIF Function in Google Sheets

Syntax

DATEDIF(start_date, end_date, unit)

Description

Calculates the number of days, months, or years between two dates.

Tips & Best Practices

Units: "Y" years, "M" months, "D" days, "YM" months ignoring years, "YD" days ignoring years.

Example

=DATEDIF(...)

The DATEDIF function belongs to the Date category of Google Sheets functions.

Related Functions

• TODAY — Returns the current date....
• NOW — Returns the current date and time....
• DATE — Converts a year, month, and day into a date....
• DATEVALUE — Converts a provided date string in a known format to a date value....
• DAY — Returns the day of the month that a specific date falls on....
• MONTH — Returns the month of the year a specific date falls in....

Need Help with DATEDIF?

If you're struggling with DATEDIF or need a custom formula built for your business, our Google Sheets experts can help. Get a free quote →