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 |