how to use excel weekday function

Return the day number from the total days of the week.

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.

Return TypeRemarks
1Numbers 1 (Sunday) through 7 (Saturday).
2Numbers 1 (Monday) through 7 (Sunday).
3Numbers 0 (Monday) through 6 (Sunday).
11Numbers 1 (Monday) through 7 (Sunday).
12Numbers 1 (Tuesday) through 7 (Monday).
13Numbers 1 (Wednesday) through 7 (Tuesday).
14Numbers 1 (Thursday) through 7 (Wednesday).
15Numbers 1 (Friday) through 7 (Thursday).
16Numbers 1 (Saturday) through 7 (Friday).
17Numbers 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 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.

Examples For Excel WEEKDAY Function

In 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.
Examples For Excel WEEKDAY Function With IF Function

Sample File

download sample file to learn about excel weekday function

What’s Next?

To learn more about Excel WEEKDAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use the weekday function, I would love to hear from you.

There is also you have WEEKNUM  function which is highly useful like weekday function. And apart from this, I have a list of excel functions and some real life formulas examples.

  • Awesome ! Thank you for this excellent explanation.