Tag: how to extract weekday in excel

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 TypeDescription1Returns A Number From 1 (Sunday) To 7 (Saturday). Default2Returns A Number From 1 (Monday) To 7 (Sunday).3Returns A Number From 0 (Monday) To 6 (Sunday).11Returns A Number From 1 (Monday) To 7 (Sunday).12Re...