WEEKNUM Function To Extract Week Number
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 1Sunday2Monday11Monday12Tuesday13Wednesday14Thursday15Friday16Saturday17Sunday21Monday