Formulas > =DATEDIF()
How to Use DATEDIF() in Google Sheets
Description
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.
Hints (2)
-
Remember to use the correct date format in A1 and B1.
-
The third argument specifies the unit of time you want to calculate.
3 Better Sheets Tutorials
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.
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
https://bettersheets.co/sheetswrapped
DATEDIF()
TODAY()
YEAR()
CRM Automations
Simple automations you can add you to your CRM to keep it clean and looking great.
DATEDIF()
IF()
ISBLANK()
WORKDAY()
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