Formatting Issues

How to Highlight Dates Within the Next 3 Months in Excel

Olivia Miller Oct 13, 2026 869 views

Question details

The user needs to highlight dates that fall specifically within the next three months without accidentally highlighting all future dates indefinitely.

How to Apply Conditional Formatting for Dates Within the Next Three Months in Excel

Product: Excel
Device & OS: not provided
Scenario: Tracking upcoming deadlines, expirations, or future events within a strictly defined 90-day or 3-month window.
Observed behavior: Using a simple rule based only on the TODAY() function results in every single future date being highlighted, rather than limiting the formatting to the required three-month timeframe.

Before you start

Ensure your date column contains valid Excel date values rather than text strings so that the TODAY() and EDATE() functions can correctly evaluate the time intervals.

Solution 1Recommended

Use the AND, TODAY, and EDATE Functions (Strictly Future Dates)

This is the recommended method to highlight dates starting exactly from today and ending exactly three months in the future, excluding any past dates.

By combining the AND function with TODAY() and EDATE(), you can set both a lower and upper boundary for your conditional formatting rule.

Select your date range

Highlight the cells containing the dates you want to format (for example, C2:C100).

Open the Conditional Formatting menu

Navigate to the Home tab on the Excel ribbon, click on 'Conditional Formatting', and select 'New Rule'.

Choose the formula option

In the New Formatting Rule dialog box, click on 'Use a formula to determine which cells to format'.

Enter the formula

Type the following formula into the box: =AND(C2>=TODAY(),C2<EDATE(TODAY(),3)). Ensure that 'C2' matches the first cell of your selected range.

Apply formatting

Click the 'Format' button, select your desired fill color or font style, and click 'OK' twice to apply the rule.

Use the AND, TODAY, and EDATE Functions (Strictly Future Dates)

Relative References: Make sure you use relative row references (like C2 instead of $C$2) in your formula so that Excel evaluates each cell in the column individually.

Solution 2

Use a Subtraction Formula (Including Past Dates within 90 Days)

If your workflow requires you to also highlight past dates up to 90 days ago alongside today, a simple subtraction formula is effective.

Efficient Spreadsheet Management

Easily Track Deadlines with WPS Spreadsheet

WPS Spreadsheet fully supports Excel's advanced conditional formatting rules, including complex date calculations with the TODAY() and EDATE() functions. You can seamlessly apply these same rules to manage your schedules and track upcoming deadlines for free.

1. Open your document in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the date values.
2. Select the target date range: Highlight the specific column or cells where you want the future dates to be formatted.
3. Apply the Conditional Formatting rule: Go to the Home tab, click 'Conditional Formatting', select 'New Rule', choose the formula option, and input your EDATE formula to highlight the upcoming three months.

100% compatible with Microsoft Excel conditional formatting formulasFamiliar and intuitive user interface with no learning curveFree, lightweight, and fast alternative for spreadsheet managementBuilt-in advanced date and time functions for dynamic reports

microsoft office alternative - wps office

Frequently Asked Questions

Why is my conditional formatting highlighting blank cells?

In Excel, empty cells are evaluated as zero, which equates to January 0, 1900. Depending on the exact formula, this might trigger a formatting rule. To exclude empty cells, add another condition to your AND statement: =AND(C2<>"", C2>=TODAY(), C2<EDATE(TODAY(),3)).

Can I highlight dates within the next 30 days instead of exactly three months?

Yes, you can simplify the formula to add exactly 30 days rather than using the EDATE function for months. Use the formula: =AND(C2>=TODAY(), C2<=TODAY()+30).

How do I highlight the entire row based on the date in a specific column?

To highlight an entire row, select your entire data table (e.g., A2:F100) instead of just the date column. In your conditional formatting formula, lock the column letter using a dollar sign so it looks like this: =AND($C2>=TODAY(), $C2<EDATE(TODAY(),3)).

Document & File Issues