How to Filter Cells by Workday/Weekend/Specific Day of the Week in Excel?
Tags: filtercellsbyworkday, kutools
Published: 2020-08-06 10:31:12

---
title: How to Filter Cells by Workday/Weekend/Specific Day of the Week in Excel?
published: true
date: 2020-08-04 10:47:10 UTC
tags: FilterCellsbyWorkday,Kutools
canonical_url: https://geekexcel.com/how-to-filter-cells-by-workday-weekend-specific-day-of-the-week-in-excel/
---

## Filter Cells by Workday/Weekend/Specific Day of the Week in Excel:

In this article, we are going to see how to **Filter Cells by Workday or Weekend or Specific day of the Week in Excel** 365 using **Kutools**.

Using Kutools you can easily complete this task because it has a **Special Filter** option. This feature helps to solve this task quickly.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 120 built-in functions. These features will help you to solve the complicated work easily. If you want to use Kutools, Install it from Excel’s official website.


## How to Filter Cells by Workday or Weekend?

Here we come up with the steps to filter cells by workday or weekend in Excel 365, do as follows.

- Select the data range in which you want to filter cells. Then enable Special Filter feature by clicking the **Kutools**  **Plus** tab, Choose the **Special Filter** option, then select the **Special Filter** option from the menu.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-4.png)

- It will open the **Special Filter dialog box**.
- **Check** the **Date** option under the **Filter rules** section.
- **Select Workdays** or **Weekend** option from the drop-down list.
- **Select** the **Font color** or **Background color** as you need from the corresponding drop-down list used the **Processing of results** section.
- Hit the **Ok** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-4.png)

- Now, **Kutools for Excel dialog box** will pop out to tell you how many cells meet the specified criteria in the table.
- Hit the **Ok** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-4.png)

- After clicking the Ok button you will see the result like below. Filtered cells ( Workdays or Weekend ) are displayed with the specified **font or background color** in the spreadsheet.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-4.png)

## How to Filter Cells by Specific Day of the Week?

To filter cells by specific day of the week using Special Filter feature, follow the below steps.

- First, you need to select the data range from the table. Then, on the **Kutools plus** tab, Choose the **Special**  **Filter** option, select the **Special Filter** option from the drop-down list.
- Now, In the **Special Filter dialog box, select** the **Date** option from the **Filter rules** section.
- **Choose the specific weekday** that you want to filter from the data list using the **drop-down menu**.
- **Select** the **Font color** or **Background color** as you need.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6-4.png)

- Now, Kutools for Excel dialog box will be opened. You have to **click**  **yes** to get the output.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/7-1.png)

- The following image has shown the filtered results highlighted with the specified font or background color.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/8.png)

### Note:

If you want to select the entire rows of the resulted cells, use **Select entire row** option in the **Special Filter dialog**  **box**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/9.png)

## Bottom Line:

In the above article, you can understand the steps to **Filter Cells by Workday or Weekend or Specific day of the Week in Excel** 365 using **Kutools**. Kindly, drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Insert or Display Images from URLs or File Paths in Excel?](https://geekexcel.com/how-to-insert-or-display-images-from-urls-or-file-paths-in-excel/)
- [Search Specific Text Values Only in Hyperlinks in Excel](https://geekexcel.com/how-to-search-specific-text-values-only-in-hyperlinks-in-excel/)
- [How to Filter All Cells Which Containing Formula in a Specified Column?](https://geekexcel.com/how-to-filter-all-cells-which-containing-formula-in-a-specified-column/)