Home Office How to find Saturday and Sunday in Excel

# How to find Saturday and Sunday in Excel

In this article, I will share with you how to use the NETWORKDAYS and WEEKDAY functions in Excel to identify the day of Saturday, Sunday or weekday.

## How to find saturday by NETWORKDAYS function

For example, use the syntax = NETWORKDAYS (A2; A2; 0) or =NETWORKDAYS(A2;A2) to check the date of Cells A2. Then you will have 2 results:

• 0: that is, check date is Saturday or Sunday.
• 1: the day is weekday.

#### You can use the NETWORKDAYS function to create Fortmat according to conditions. The following steps will help you:

Step 1: Select the data area you want to Fortmat and then on the Home tab, select Conditional Formatting.

Step 2: Then, in the New Formattings Rule window, you need to set up some steps such as:

• Select a Rule Type ⇒ Use formula to determine which cells to format.
• In the Format values where … option box, you will use the condition = NETWORKDAYS (A2; A2) = 0
• Select Format to choose the colors and fonts for Cells to meet the conditions.

Step 3: Select OK to apply the newly created condition, immediately the Cells whose value is Saturday or Sunday will be colored.

### How to find Saturday by WEEKDAY function

In WEEKDAY function, if you use the [return_type] argument of 2, the result will be 1 ⇒ 7, in order starting from Monday ⇒ Sunday. And, the last 2 days will be 6 and 7 corresponding to Saturday and Sunday. So when you use the IF function, you can easily separate Saturday and Sunday.

In the example below, when I use the function = IF (WEEKDAY (A2; 2) <6; 1; 0), the result is:

• 1: if the result of WEEKDAY <6, the test date is Monday or Friday.
• 0: if the result of WEEKDAY> = 6, is Saturday or Sunday respectively.

Above are 2 ways to help you split the week by Saturday and Sunday. Hope this sharing is useful to you.