Kornilios Ampatzis/ May 2, 2019/ Functions

It returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 to 7.

The syntax of the function is the following:

WEEKDAY(serial_number, [return_type])

serial_number: It represents the date for which we want to return the day of the week.
[return_type]: Optional. Default is 1. It is a number that defines the type of the return value.
return_typeDefinition
1Returns (1=Sunday to 7=Saturday)
2Returns (1=Monday to 7=Sunday)
3Returns (0=Monday to 6=Sunday)
11Returns (1=Monday to 7=Sunday)
12Returns (1=Tuesday to 7=Monday)
13Returns (1=Wednesday to 7=Tuesday)
14Returns (1=Thursday to 7=Wednesday)
15Returns (1=Friday to 7=Thursday)
16Returns (1=Saturday to 7=Friday)
17Returns (1=Sunday to 7=Saturday)

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the WEEKDAY function:

Use the proper formula in the cell I2 to display the number of the day of the week (Sunday=1,Monday=2,…), which appears in the cell A2.

Share this Post