WEEKDAY Function in Excel, Google Sheets, Airtable & Notion
WEEKDAY tells you which day of the week a date falls on, as a number. Which number means Monday depends on the return type — and on the app.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | WEEKDAY(serial_number, [return_type])Also accepts return types 11–17 (week starting Monday…Sunday, numbered from 1). |
| Google Sheets | ✔ Built in | WEEKDAY(date, [type])Types 1, 2 and 3 only. |
| Airtable | ✔ Built in | WEEKDAY(date, [startDayOfWeek])Returns 0–6 with 0 = Sunday. The copy-ready formula converts this to the Excel numbering you picked. |
| Notion | ✔ Built in | day(date)Returns 1–7 with 1 = Monday … 7 = Sunday, which equals Excel type 2. |
| Excel | =WEEKDAY(DATE(2024, 3, 15)) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =WEEKDAY(DATE(2024, 3, 15)) | open sheets.new ↗ |
| Airtable | WEEKDAY(DATETIME_PARSE("2024-03-15", "YYYY-MM-DD")) + 1 | |
| Notion | mod(day(parseDate("2024-03-15")), 7) + 1 |
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 | The date to check. |
[return_type] optional | 1 (default): Sunday = 1 … Saturday = 7. 2: Monday = 1 … Sunday = 7. 3: Monday = 0 … Sunday = 6. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=WEEKDAY(DATE(2024, 3, 15)) | 6 | 15 March 2024 is a Friday; type 1 counts Sunday as 1. | |
=WEEKDAY(DATE(2024, 3, 15), 2) | 5 | Type 2 counts Monday as 1, so Friday is 5. | |
=WEEKDAY(DATE(2024, 3, 17), 3) | 6 | Sunday with type 3 (Monday = 0). | |
=WEEKDAY(A2, 2) > 5 | TRUE on weekends | With type 2, Saturday and Sunday are 6 and 7. |
Examples use Excel / Google Sheets syntax unless noted.
How WEEKDAY works
Every app numbers the week differently, so check the numbering before you compare against a constant. Excel and Google Sheets default to type 1 (Sunday = 1), which is the US convention; most of the world thinks of Monday as day 1, which is type 2. Type 2 makes weekend tests simple: =WEEKDAY(A2, 2) > 5 is TRUE on Saturday and Sunday.
Airtable's WEEKDAY() is zero-based: Sunday = 0 through Saturday = 6, so add 1 to match Excel's default. Its optional second argument "Monday" makes the week start on Monday (still counting from 0). Notion's day() uses the ISO numbering, Monday = 1 through Sunday = 7, the same as Excel type 2. The copy-ready formulas on this page convert each app to the return type you choose.
If you want the weekday as a word, formatting is easier than WEEKDAY: =TEXT(A2, "dddd") gives “Friday” and "ddd" gives “Fri”. To count or skip working days use NETWORKDAYS and WORKDAY rather than testing each date.
Frequently Asked Questions
- How do I check if a date is a weekend?
- Use
=WEEKDAY(A2, 2) > 5. In Airtable:OR(WEEKDAY({Date}) = 0, WEEKDAY({Date}) = 6). In Notion:day(prop("Date")) > 5. - Why is my WEEKDAY one off between apps?
- Excel type 1 starts at Sunday = 1, Airtable at Sunday = 0 and Notion at Monday = 1. Pick the conversion shown in the tester above.