Weekday - Excel Function

TIMEVALUE function takes at least one argument and returns the number of a day.


= WEEKDAY(serial_number, [return_type]))

  • serial_number - A serial_number that represents a date. Dates should be entered by using the DATE function.
  • return_type - [Optional] Different type of numbering, depending on the selected option.


=WEEKDAY(DATE(2011,11,7)) returns 2 (Monday), because Sunday is numbered 1 and Monday is numbered 2.

=WEEKDAY(DATE(2011,11,7),14) returns 5 (Monday), because numbering of days starts from Thursday - 1, Friday - 2, Saturday - 3, Sunday - 4, Monday - 5.

Polska wersja kursuExcel, gdzie możesz nauczyć się podstawowej obsługi Excela.