DEFINITION : WEEKNUM Function Need A Valid Date Or A Serial Number Of A Date And In Returns It Gives A Week Number From 1 To 54 Which Corresponds Week Of A Year. The WEEKNUM Function Begin Counting With The Week Contains 1St January. As A Default Week It Begin From Sunday For Which Return_Type Is 1. The Return_Type Parameter In WEEKNUM Function Is The Day Begin Number. By Default Value Is 1 And The Day Is Sunday. For More Details Please Check Image And Table Chart Below.
SYNTAX : =WEEKNUM (SERIAL_NUM, [RETURN_TYPE])
| Return Type | Week Begin Name |
|---|---|
| 1 | Sunday |
| 2 | Monday |
| 11 | Monday |
| 12 | Tuesday |
| 13 | Wednesday |
| 14 | Thursday |
| 15 | Friday |
| 16 | Saturday |
| 17 | Sunday |
| 21 | Monday |
