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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | DAY(serial_number) |
| Google Sheets | ✔ Built in | DAY(date) |
| Airtable | ✔ Built in | DAY(date) |
| Notion | ✔ Built in | date(date)In Notion date() is the day of the month. Notion's day() is the day of the week (1 = Monday). |
| Excel | =DAY(DATE(2024, 3, 15)) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =DAY(DATE(2024, 3, 15)) | open sheets.new ↗ |
| Airtable | DAY(DATETIME_PARSE("2024-03-15", "YYYY-MM-DD")) | |
| Notion | date(parseDate("2024-03-15")) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
date | A date, a cell containing a date, or a formula that returns one. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=DAY(DATE(2024, 3, 15)) | 15 | ||
=DAY(EOMONTH(A2, 0)) | Days in the month | The last day's number is the length of the month, e.g. 29 for February 2024. | |
=A2 - DAY(A2) + 1 | First of the month | Subtract 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 orformatDate(prop("Date"), "dddd")in Notion. For a number use WEEKDAY.