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.
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).|
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.