Spreadsheet formulas explained, side by side

DAY Function in Excel, Google Sheets, Airtable & Notion

DAY returns the day of the month, from 1 to 31. It does not return the weekday — for Monday, Tuesday and so on use WEEKDAY.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inDAY(serial_number)
Google Sheets✔ Built inDAY(date)
Airtable✔ Built inDAY(date)
Notion✔ Built indate(date)
In Notion date() is the day of the month. Notion's day() is the day of the week (1 = Monday).
Try DAY with your own values
Result (as Excel & Google Sheets return it)
15
Your formula, ready to paste
Excel=DAY(DATE(2024, 3, 15)) open excel.new ↗
Google Sheets=DAY(DATE(2024, 3, 15)) open sheets.new ↗
AirtableDAY(DATETIME_PARSE("2024-03-15", "YYYY-MM-DD"))
Notiondate(parseDate("2024-03-15"))

Arguments

ArgumentWhat it means
dateA date, a cell containing a date, or a formula that returns one.

Examples

FormulaResultWhyCopy
=DAY(DATE(2024, 3, 15))15
=DAY(EOMONTH(A2, 0))Days in the monthThe last day's number is the length of the month, e.g. 29 for February 2024.
=A2 - DAY(A2) + 1First of the monthSubtract the day number to step back to the start of the month.

Examples use Excel / Google Sheets syntax unless noted.

How DAY works

DAY is mostly used to take a date apart and put it back together. =DAY(EOMONTH(A2, 0)) tells you how many days a month has, and =A2 - DAY(A2) + 1 moves any date back to the 1st.

The name is the biggest trap when switching apps. In Excel, Google Sheets and Airtable, DAY is the day of the month. In Notion, day() returns the day of the week (1 = Monday … 7 = Sunday) and the day of the month is date(). A Notion formula that uses day() where it meant the date will quietly return numbers from 1 to 7.

Frequently Asked Questions

How do I get the weekday name instead?
Use =TEXT(A2, "dddd") in Excel/Sheets, DATETIME_FORMAT({Date}, "dddd") in Airtable or formatDate(prop("Date"), "dddd") in Notion. For a number use WEEKDAY.

Part of the Date & Time functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.