Excel Formulas to Highlight the Cells Between Two Dates!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-26 05:46:39

---
title: Excel Formulas to Highlight the Cells Between Two Dates!!
published: true
date: 2021-03-25 11:57:52 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-the-cells-between-two-dates/
---

Assume that, you have a list of dates in your worksheet, and you need to highlight the cells or rows which are in between two defined dates. How could you deal with this task in Excel? This article will talk about how to **highlight the cells between two dates in Excel**. Let’s see them below!! 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)

[![Highlight Cells between two dates](https://geekexcel.com/wp-content/uploads/2021/03/Highlight-Cells-between-two-dates.png)](https://geekexcel.com/excel-formulas-to-highlight-the-cells-between-two-dates/highlight-cells-between-two-dates/#main)<figcaption id="caption-attachment-22656">Highlight Cells between two dates</figcaption>
## Generic Formula:

- You can use the below formula to format the cells between two defined dates in Excel.

**=[AND](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/)(A1>=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/) (1),A1<=DATE (2))**

## Syntax Explanations:

- **AND** – This function will check multiple conditions and returns [**TRUE **](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)if all the conditions are evaluated as true otherwise returns **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)**. Read more on the[**AND Function**](https://geekexcel.com/how-to-use-logical-function-and-in-excel-365/).
- **DATE** – In Excel, the [**DATE function**](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/) helps to combine three different values and returns them as a date.
- **A1** – It represents the input value.
- **Date 1 &2** – It is the defined date that helps to format the cells.
- **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:

Refer to the below example.

- First, we will enter the input values in **Column B** to **Column E**.
- Here, we are going to highlight the cells between the given dates which are placed in **Column G**  And **Column H**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-30.png)<figcaption id="caption-attachment-22653">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, we will get the result as shown below.

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

## Verdict:

Hope you like this article on how to highlight the cells between two dates in Excel. Let me know if you have any **doubts** regarding this article or any other article on this site. Thank you for visiting our site!! To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Highlight the Cells that Equal to Certain Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-equal-to-certain-criteria/)**
- **[Excel Formulas to Highlight Bottom Values with Conditional Formatting!!](https://geekexcel.com/excel-formulas-to-highlight-bottom-values-with-conditional-formatting/)**