Skip to content
Excel

WEEKDAY function in Excel

Converts a serial number to a day of the week

=WEEKDAY(serial_number, [return_type])

WEEKDAY syntax and parameters

Two arguments, one required.

  • serial_numbernumberRequired

    A sequential number that represents the date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

  • return_typenumberOptional

    A number that determines the type of return value.

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 Google Sheets

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 Excel gets this done.