Tuesday, November 5

Tag: excel WEEKDAY Function

WEEKDAY Function To Extract Day From Date

WEEKDAY Function To Extract Day From Date

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