WEEKDAY tells you which day of the week a date falls on, as a number. The crucial detail is return_type: by default Sunday is 1, but return_type 2 makes Monday 1 (the ISO convention) and return_type 3 makes Monday 0. Choosing the wrong return_type is the single most common WEEKDAY mistake.
Returns a number. The weekday under the chosen return_type scheme; invalid return_type returns #NUM!.
Same Monday, three different numbers. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =WEEKDAY(C2) | 2 | Default: Sun=1, so Monday=2 |
| =WEEKDAY(C2,1) | 2 | return_type 1: Sun=1..Sat=7 |
| =WEEKDAY(C2,2) | 1 | return_type 2: Mon=1..Sun=7 |
| =WEEKDAY(C2,3) | 0 | return_type 3: Mon=0..Sun=6 |
| =WEEKDAY(C7,2) | 7 | Sunday under Mon=1 |
| =WEEKDAY(C3,1) | 5 | Thursday under Sun=1 |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to compare the three return_type schemes.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
WEEKDAY is a core date function present in every Excel version; return_type options 1–3 are universal.
| Platform | Support | Notes | Gotcha |
|---|
WEEKDAY is one piece. The full course walks the toolkit end to end with live, measured examples.