Home/Formulas/Date/DATEDIF
Datemedium

DATEDIF()

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

Syntax
fx
=DATEDIF(start_date, end_date, unit)
Example
fx
=DATEDIF(A1, TODAY(), "Y")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and DATEDIF isn't one of them yet.

Related formulas
NETWORKDAYS()
Returns the count of working days (Mon-Fri) between two dates, excluding optional holidays.
EDATE()
Returns the date a specified number of months before or after another date.
Used by
EDATE()
Returns the date a specified number of months before or after another date.
NETWORKDAYS()
Returns the count of working days (Mon-Fri) between two dates, excluding optional holidays.
More Date formulas →Keyboard shortcuts for Sheets →