top of page


The WEEKDAY function provides the numerical representation of the day in a week, ranging from 1 to 7.

Syntax of WEEKDAY: =WEEKDAY(serial_number, [return_type])

  • serial_number - The date for which we wish to determine the day number

  • [return_type] - Specifies the starting day of the week. By default, if this argument is not provided, Sunday is considered the first day of the week. To set Monday as the first day of the week, we can enter "2" as the value for this argument.

bottom of page