Date & Time Functions
Building dates, adding months, counting days and workdays. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| DATE | Build a date from a year, month and day | ✔ | ✔ | ≈ | ≈ |
| TODAY | The current date, updated automatically | ✔ | ✔ | ✔ | ✔ |
| YEAR | Get the year from a date | ✔ | ✔ | ✔ | ✔ |
| MONTH | Get the month number (1–12) from a date | ✔ | ✔ | ✔ | ✔ |
| DAY | Get the day of the month (1–31) from a date | ✔ | ✔ | ✔ | ✔ |
| WEEKDAY | Day of the week as a number | ✔ | ✔ | ✔ | ✔ |
| EDATE | Add or subtract whole months from a date | ✔ | ✔ | ✔ | ✔ |
| EOMONTH | Last day of the month, a number of months away | ✔ | ✔ | ≈ | ≈ |
| DATEDIF | Whole years, months or days between two dates | ✔ | ✔ | ≈ | ≈ |
| NETWORKDAYS | Count working days (Mon–Fri) between two dates | ✔ | ✔ | ✔ | ✘ |
| WORKDAY | Date a number of working days away | ✔ | ✔ | ✔ | ✘ |
| DAYS | Number of days between two dates | ✔ | ✔ | ✔ | ✔ |
✔ built-in function ≈ works with a workaround formula ✘ not available