Excel WEEKDAY Function
This tutorial is talking about the formula syntax and usage of WEEKDAY function in Excel.
The Microsoft Excel WEEKDAY function returns an integer number from 1 to 7 to represent the day of the week for a given date in Excel.
The below table can help you to know more about the return_type argument.
| Return Type || Number returned || Day scope |
|1 or omitted||1-7||Sunday-Saturday|
Remark: For the same dates, different return_types will cause different results with the WEEKDAY function.
For getting day of week based on a given date, please do as follows.
1. Click on the cell you want to output the result, enter formula =WEEKDAY(B5,1) into the Formula Bar and press the Enter key.
2. Keep selecting the result cell, drag the Fill Handle down to apply the formula to other cells.
1. C4 is the date cell you will get day of the week based on.
2. If you want some specified the start day and end day of a week, such as starts on Monday and ends with Sunday, you can choose number 2 as the return_type in the formula. See screenshot:
For the result number of above screenshot, 3 representing Wednesday of the week, 4 is Thursday of the week, 5 and 6 representing Friday and Saturday.