WEEKDAY

Get the day of the week as a number

Sponsored Link

WEEKDAY

Purpose 

Get the day of the week as a number

Return value 

A number between 0 and 7.

Syntax 

=WEEKDAY (serial_number, [return_type])

Arguments 

  • serial_number - The date for which you want to get the day of week.
  • return_type - [optional] A number 1-3 representing day of week mapping scheme. Default is 1.

Usage notes 

return_type specifies the scheme used to map the day of week. The default is 1. The available mapping schemes are as follows:

return_type 1: Numbers 1-7 (Sunday through Saturday) - default
return_type 2: Numbers 1-7 (Monday through Sunday)
return_type 3: Numbers 0-6 (Monday through Sunday)

Sponsored Link

0 votes. 0 / 5