Calculates the number of days, months, or years between two dates.
81% OFF online library of tutorials for mastering Google Sheets
DATEDIF()
Description
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.