81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

DATEDIF()

Description

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

How To Use in Sheets

DATEDIF(start_date, end_date, unit)

External Links

Google Sheets - Calculate Age in Days, Months, or Years

Learn how to use the DATEDIF function to calculate age if you have a start and end date. The output can be days, months, years, or a combination.

1Better Sheets Tutorial

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.