DEFINITION: Weekday Function Returns The Day Of The Week In Numeric Number From A Give Valid Date Or A Date Serial Number. By Default Weekday Returns 1 For Sunday And 7 For Saturday. To Find The Serial Number Of A Date Change The Cell Format To General Of A Cell Which Contain The Valid Date And Try Adding Serial Number In Place Of Date And You Will Get The Same Result.
SYNTAX:- =WEEKDAY (SERIAL_NUMBER, [RETURN_TYPE]) Return Type Is optional As It Is In Square Brackets. Any Parameter In Excel Having Square Bracket Is Consider As Optional.
| Return Type | Description |
|---|---|
| 1 | Returns A Number From 1 (Sunday) To 7 (Saturday). Default |
| 2 | Returns A Number From 1 (Monday) To 7 (Sunday). |
| 3 | Returns A Number From 0 (Monday) To 6 (Sunday). |
| 11 | Returns A Number From 1 (Monday) To 7 (Sunday). |
| 12 | Returns A Number From 1 (Tuesday) To 7 (Monday). |
| 13 | Returns A Number From 1 (Wednesday) To 7 (Tuesday). |
| 14 | Returns A Number From 1 (Thursday) To 7 (Wednesday). |
| 15 | Returns A Number From 1 (Friday) To 7 (Thursday). |
| 16 | Returns A Number From 1 (Saturday) To 7 (Friday). |
| 17 | Returns A Number From 1 (Sunday) To 7 (Saturday). |
