Learn How to Use Microsoft Excel WEEKDAY Function

Microsoft Excel WEEKDAY Function

The Microsoft Excel WEEKDAY function's primary purpose is to get the day of the week as a number. So with the help of the WEEKDAY function, you can take a date and return a number between 1 to 7, representing seven days of the week; by default, the number 1 returns for Sunday and 7 returns for Saturday. You can also use the WEEKDAY function inside the other formulas and check the day of the week.

WEEKDAY Function Return Value

The WEEKDAY function will return the numeric value between 1 to 7, representing days in a week.

WEEKDAY Function Syntax

= WEEKDAY(serial-number, [return-type])

Where the arguments:

• serial-number: It is the date of the week for which you want to get the day of the week.
• return-type: It is the number representing the day of the week mapping scheme (optional).

How to Use Microsoft Excel WEEKDAY Function?

The WEEKDAY function accepts the date and returns the number between 1 to 7, representing a day of the week. The WEEKDAY returns 1 for Sunday and 7 for Saturday as a default. More details are given in the table below:

Return Value                         Meaning

1                                              Sunday

2                                              Monday

3                                              Tuesday

4                                              Wednesday

5                                              Thursday

6                                              Friday

7                                              Saturday

The WEEKDAY function supports various numbering schemes, and the return type arguments determine which technique is used to map the particular day.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel