WEEKDAY Function in Excel with step by step example

WEEKDAY Function in Excel with step by step example

WEEKDAY

Returns the day of the week from given date. The day represents a valid integer value between 1 to 7 where 1 = Sunday and 7 = Saturday.

Syntax

=WEEKDAY(serial_number, [return_type])

  • serial_number: a mandatory parameter, refers to a valid date sequence from which you wish to extract day of the week.
  • return_type: an optional parameter, to determines the return type value. Followings are the types:
    • 1: Numbers 1 (Sunday) through 7 (Saturday) default
    • 2: Numbers 1 (Monday) through 7 (Sunday)
    • 3: Numbers 0 (Monday) through 6 (Sunday)
    • 11: Numbers 1 (Monday) through 7 (Sunday)
    • 12: Numbers 1 (Tuesday) through 7 (Monday)
    • 13: Numbers 1 (Wednesday) through 7 (Tuesday)
    • 14: Numbers 1 (Thursday) through 7 (Wednesday)
    • 15: Numbers 1 (Friday) through 7 (Thursday)
    • 16: Numbers 1 (Saturday) through 7 (Friday)
    • 17: Numbers 1 (Sunday) through 7 (Saturday)

Formula

Output

Next >> Binary to Octal Conversion in Excel with example

Leave a Reply

Your email address will not be published.