# Learn How to Use Microsoft Excel WEEKDAY Function

Written by | 0 Comments | 826 Views

In this article, you will learn how to use the Microsoft Excel WEEKDAY function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel WEEKDAY function return value and syntax with the help of some examples.

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

|