Excel Formulas to Highlight the Dates that are Weekends!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-30 12:06:16

---
title: Excel Formulas to Highlight the Dates that are Weekends!!
published: true
date: 2021-03-30 04:32:00 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-the-dates-that-are-weekends/
---

In Excel, the Conditional Formatting feature is a very useful and multifunctional tool. Using this option you can do many tasks. Today, I will talk about how to **highlight the dates that are weekends in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to highlight weekends](https://geekexcel.com/wp-content/uploads/2021/03/Formulas-to-highlight-weekends.png)](https://geekexcel.com/excel-formulas-to-highlight-the-dates-that-are-weekends/formulas-to-highlight-weekends/#main)<figcaption id="caption-attachment-22697">Formulas to highlight weekends</figcaption>
## General Formula:

- To highlight the weekends in Excel, you can use the below formula.

**=[OR](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/)([WEEKDAY](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)(A1)=7,WEEKDAY(A1)=1)**

## Syntax Explanations:

- **OR** – This is a logical function to test multiple conditions at the same time. It will return either **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** or **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)**. Read more on the [**OR function**](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/).
- **WEEKDAY** – In Excel, the **[WEEKDAY Function](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)** helps to return a number (ranging from 1 to 7) that represents the day of the week for a given date.
- **A1** – It represents the input range.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s see the below example. Here we will show how to highlight the weekends.

- First, we will enter the input dates in **Column B** to **Column E**.
- From these inputs, we want to highlight the weekends.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-34.png)<figcaption id="caption-attachment-22694">Input Ranges</figcaption>

- So apply the above-given formula in the conditional formatting option.
- To know  **how to apply conditional formatting**  in Excel, just **refer to this article<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Finally, it will highlight the result and displayed it as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-38.png)<figcaption id="caption-attachment-22695">Result</figcaption>

## Bottom-Line:

In this tutorial, you can get some clarification on how to **highlight the weekends in Excel**. Hope you like this article. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. Thanks for visiting!!  To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Calculate the Basic Rates with VLOOKUP!!](https://geekexcel.com/excel-formulas-find-basic-rates-with-vlookup/)**
- **[Excel Formulas to Highlight the Dates in Same Month and Year!!](https://geekexcel.com/excel-formulas-to-highlight-the-dates-in-same-month-and-year/)**