Spreadsheet formulas explained, side by side

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.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
DATEBuild a date from a year, month and day✔✔≈≈
TODAYThe current date, updated automatically✔✔✔✔
YEARGet the year from a date✔✔✔✔
MONTHGet the month number (1–12) from a date✔✔✔✔
DAYGet the day of the month (1–31) from a date✔✔✔✔
WEEKDAYDay of the week as a number✔✔✔✔
EDATEAdd or subtract whole months from a date✔✔✔✔
EOMONTHLast day of the month, a number of months away✔✔≈≈
DATEDIFWhole years, months or days between two dates✔✔≈≈
NETWORKDAYSCount working days (Mon–Fri) between two dates✔✔✔✘
WORKDAYDate a number of working days away✔✔✔✘
DAYSNumber of days between two dates✔✔✔✔

✔ built-in function   ≈ works with a workaround formula   ✘ not available