How to use Excel WEEKDAY Function

    Quick Intro

    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.

    Syntax

    WEEKDAY(serial_number,return_type)

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

    Examples

    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.

    Examples For Excel WEEKDAY Function

    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.

    Examples For Excel WEEKDAY Function With IF Function

    Sample File

    download sample file to learn more about this tips

    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 it, I would love to hear from you.

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


    • Awesome ! Thank you for this excellent explanation.