Tuesday, November 5

Tag: use of WEEKNUM Function in excel

WEEKNUM Function To Extract Week Number

WEEKNUM Function To Extract Week Number

Date And Time, FORMULAS
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