WEEKDAY
Returns the day of the week for a date serial. return_type: 1 = Sun–Sat → 1–7 (default), 2 = Mon–Sun → 1–7, 3 = Mon–Sun → 0–6.
| Category | Date |
| Syntax | WEEKDAY(serial_number, [return_type]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
serial_number | Required | The Excel date serial number. |
return_type | Required | Optional numbering scheme: 1 (default), 2, or 3. |
Example
WEEKDAY()
Auto-generated from the EngCanvas function registry.