WEEKDAY

Purpose

• Provides the day of the week (in numerical terms: 1-7) when given a specific date

Example

• Here is a screenshot, for reference:

Syntax

• =WEEKDAY(serial_number, return_type)

Arguments

• serial_number
  • This is the date in question, formatted as a serial number (and you need its weekday number)
  • This can be a hard-coded number, cell reference, or calculation
• return_type [optional]
  • This allows you to specify which day of the week is number 1, which is number 2, which is number 3, etc.
    • When omitted, the number 1 represents Sunday
    • When the return_type is 2, the number 1 represents Monday
    • etc.
  • See the link below for a full list of return types possible
  • This can be a hard-coded number, cell reference, or calculation

External Links

• Microsoft: WEEKDAY Function