Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TODAY / DATEDIF
TODAY returns the current date; DATEDIF measures the difference in days, months, or years — useful for ages and tenure.
Topic:Date arithmeticExcel
=DATEDIF(A2, TODAY(), "Y")Google Sheets
=DATEDIF(A2, TODAY(), "Y")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the start date.
- 2TODAY() is the end date.
- 3"Y" returns whole years between them.
More on Date arithmetic
See all →Reference
DATEDIF
Calculates the difference between two dates in years, months, or days using a unit code string.
How-toHow to calculate age from a date of birth
Turn a birth date into an age in years with DATEDIF and TODAY. Works the same in Excel and Google Sheets.
How-toHow to calculate days between two dates
Subtract one date from another to get the number of days, or count working days with NETWORKDAYS. Works in both apps.
How-toHow to add months to a date
Shift a date forward or back by a number of months with EDATE — it handles month lengths correctly. Works in both apps.
How-toHow to flag overdue dates
Mark rows whose due date has passed by comparing it to TODAY() with IF. Works the same in Excel and Google Sheets.
How-toHow to calculate age from a birthday
Use DATEDIF with TODAY() to calculate a person's exact age in years from a birth date cell in Excel and Google Sheets.