Skip to content
Google Sheets

WEEKDAY function in Google Sheets

Returns a number representing the day of the week of the date provided.

=WEEKDAY(date, [type])

WEEKDAY syntax and parameters

Two arguments, one required.

  • dateanyRequired

    The date for which to determine the day of the week. Must be a reference to a cell containing a date, a function returning a date type, or a number.

  • typenumberOptional

    [ OPTIONAL - 1 by default ] - A number indicating which numbering system to use to represent weekdays. By default counts starting with Sunday = 1. If type is 1, days are counted from Sunday and the value of Sunday is 1, therefore the value of Saturday is 7. If type is 2, days are counted from Monday and the value of Monday is 1, therefore the value of Sunday is 7. If type is 3, days are counted from Monday and the value of Monday is 0, therefore the value of Sunday is 6. If type is 11, days are counted from Monday and the value of Monday is 1, therefore the value of Sunday is 7. If type is 12, days are counted from Tuesday and the value of Tuesday is 1, therefore the value of Monday is 7. If type is 13, days are counted from Wednesday and the value of Wednesday is 1, therefore the value of Tuesday is 7. If type is 14, days are counted from Thursday and the value of Thursday is 1, therefore the value of Wednesday is 7. If type is 15, days are counted from Friday and the value of Friday is 1, therefore the value of Thursday is 7. If type is 16, days are counted from Saturday and the value of Saturday is 1, therefore the value of Friday is 7. If type is 17, days are counted from Sunday and the value of Sunday is 1, therefore the value of Saturday is 7.

WEEKDAY examples

Formulas you'll actually reuse.

  1. The day of the week as 1–7 with Sunday = 1 — 14 Aug 2026 is a Friday:

    =WEEKDAY(B2)

    Result6

  2. Is it a weekend? Type 2 makes Monday 1, so 6 and 7 are Sat/Sun:

    =WEEKDAY(B2, 2) > 5

    ResultFALSE

WEEKDAY in Excel

Same name — your formula ports as-is.

Try WEEKDAY in the playground

Edit the example — nothing to install.

Preloaded with the WEEKDAY formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.