Sometimes you need to know what day is the order of the week for your calculations, the WEEKDAY function in Excel is a calculation function that can help and help you do this. Let’s find out about the WEEKDAY function in Excel through the tips below.
The WEEKDAY function syntax has the following arguments:
- Serial_number (required argument) – This is a sequential number representing the date of the day that we are trying to find.
- Return_type (optional argument) – This specifies which integers are to be assigned to each weekday. Possible values are:
WEEKDAY accepts a date and returns a number between 1-7 representing the day of week for that date. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, as shown in the table below:
WEEKDAY supports several numbering schemes. The return type argument determines which scheme used to map each day of week to a number. The return type is optional and defaults to 1. The table below shows the result and mapping associated with each return type:
|Return type||Numeric result||Day mapping|
Note: the WEEKDAY function will return a value even when the date is empty. Take care to trap this result if blank dates are possible.
Example: Let’s look at some Excel WEEKDAY function examples and explore how to use the WEEKDAY function as a worksheet function in Microsoft Excel:
Wish you success and soon remember the formula of Weekday function to serve calculations when working on Excel.