How to Use DATEDIF() in Google Sheets

Description

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

How To Actually Use DATEDIF() in Sheets

DATEDIF(start_date, end_date, unit)

Try DATEDIF yourself

In cells A1 and B1, enter a birth date and today's date respectively. Use the DATEDIF function in cell C1 to calculate the age in years based on these dates.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

How Many Days Between Two Dates?

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.

Intermediate

DATE() DATEDIF()

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get this free review of your Google Sheets in 2024.
https://bettersheets.co/sheetswrapped

Beginner

DATEDIF() TODAY() YEAR()

CRM Automations

Simple automations you can add you to your CRM to keep it clean and looking great.

Intermediate

DATEDIF() IF() ISBLANK() WORKDAY()

Transcript-matched member videos for DATEDIF(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Unlock these tutorials

Learn more about the DATEDIF() formula:

Generate a DATEDIF() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses DATEDIF(). 2 free AI generations, no signup. Members get unlimited use.

Generate a DATEDIF() formula