Excel Formulas to Highlight the Dates Greater Than Given Date!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-25 12:03:15

---
title: Excel Formulas to Highlight the Dates Greater Than Given Date!!
published: true
date: 2021-03-25 07:08:14 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-dates-greater-than-given/
---

For a list of dates, and you want to highlight the date cells that are greater than so many days since now, would you highlight them one by one manually? This tutorial introduces how to **highlight the dates greater than a given date 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)

[![Highlight dates greater than](https://geekexcel.com/wp-content/uploads/2021/03/Highlight-dates-greater-than.png)](https://geekexcel.com/excel-formulas-to-highlight-dates-greater-than-given/highlight-dates-greater-than/#main)<figcaption id="caption-attachment-22661">Highlight dates greater than</figcaption>
## General Formula:

- To highlight the dates greater than a certain date you can use the below formula.

**=A1>[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([year](https://geekexcel.com/how-to-use-year-function-in-excel-365/),[month](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/),[day](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/))**

## Syntax Explanations:

- **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.
- **YEAR** – The [**YEAR Function**](https://geekexcel.com/how-to-use-year-function-in-excel-365/)will extract the year from the given date and return the year as a 4-digit number.
- **MONTH** – This function helps to extract the month number ranging from **1 (JAN)** to 1**2 (DEC)** from the given date and displays the output. Read more on the [**MONTH Function**](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/).
- **DAY** –  In Excel, the [**DAY function**](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/) is used for finding the day from the given set of dates.
- **A1** – It represents the input value.
- **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.

## Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B** to **Column E**.
- Now, we are going to highlight the input dates that are greater than the given date in **Column G**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-31.png)<figcaption id="caption-attachment-22662">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-35.png)<figcaption id="caption-attachment-22663">Result</figcaption>

## Conclusion:

From this article, you can get some clarification on how to **highlight the cells when the date is greater than a certain date in Excel**. If you have any other **ideas** or **question** , do share with us here in the **comments** section below. 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 contain Certain Value!!](https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-contains-certain-value/)**
- **[Excel Formulas to Highlight the Duplicate Values from Two Columns!!](https://geekexcel.com/excel-formulas-highlight-duplicate-values-from-two-columns/)**