Use WEEKDAY Function to get weekday number of a day for a serial number which is a represent a valid date you have supplied.
In simple words, it will return the day number ranging from 1 to 7 in a week. Let’s say if you specify 01-Feb-2017 which is Wednesday, it will return 3 in the result, the reason is Wednesday is the third day of the week.
- serial_number A serial number which represents the date as per excel’s date system.
- return_type A number to specify starting and the ending day of the week to consider while getting day number.
You can use different numbers to use in as return_type as per below table.
|1||Numbers 1 (Sunday) through 7 (Saturday).|
|2||Numbers 1 (Monday) through 7 (Sunday).|
|3||Numbers 0 (Monday) through 6 (Sunday).|
|11||Numbers 1 (Monday) through 7 (Sunday).|
|12||Numbers 1 (Tuesday) through 7 (Monday).|
|13||Numbers 1 (Wednesday) through 7 (Tuesday).|
|14||Numbers 1 (Thursday) through 7 (Wednesday).|
|15||Numbers 1 (Friday) through 7 (Thursday).|
|16||Numbers 1 (Saturday) through 7 (Friday).|
|17||Numbers 1 (Sunday) through 7 (Saturday).|
More Information on Excel WEEKDAY Function
- You can also use a date which is in textual form, a result of another function, or you can enter a date directly into the function by using double quotation marks.
- If you skip specifying return type it will take 1 as default.
In the below example, I have used weekday function with TODAY to get dynamic weekday.
It will give you the weekday whenever current date changes. You can use this method in your dashboards to trigger some values when needs to change when weekday change.
In the below example, I have used weekday with IF to create a formula which first checks weekday of a date and return “Weekday” or “Weekend” basis on the value return from weekday function.
To learn more about Excel WEEKDAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.