In this article:

Conditional Formatting for Dates Within 7 Days in Google Sheets

Conditional Formatting for Dates Within 7 Days in Google Sheets

Follow the steps below to set conditional formatting for dates within 7 days in Google Sheets.

Step 1: Select Your Date Range

Click and drag to select the range of cells that contain the dates you want to format. This could be a column or a row of dates, depending on how your sheet is organized.

google sheets conditional formatting date within 7 days

Step 2: Open Conditional Formatting Settings

Go to the top menu and click on Format. From the dropdown menu, choose Conditional formatting. This will open the Conditional format rules panel on the right side of your screen.

conditional formatting in google sheets for dates within 7 days

Step 3: Set Your Range

In the Conditional format rules panel, you should see the range you selected already filled in under "Apply to range". If not, you can manually enter the range or select it again here.

conditional formatting for dates within 7 days in google sheets

Step 4: Create Your Custom Formula

In the panel, look for the “Format cells if” dropdown and select Custom formula is. In the formula box that appears, enter the following formula:

=AND(A1<=TODAY()+7, A1>=TODAY())

Note: Make sure to replace A1 with the cell reference of the first cell in your selected range. This formula checks if a date is within the next 7 days from today.

google sheets conditional formatting for dates within 7 days

Step 5: Choose Your Formatting

Below the formula box, you'll see options for setting the format. You can choose a background color, text color, and other styling options to apply to cells that meet the condition. 

Pick a color that will make these dates stand out. For example, a bright color like yellow or green can be a good choice.

apply conditional formatting for dates within 7 days in google sheets

Step 6: Apply and Finish

After selecting your formatting options, click on the Done button.

Your conditional formatting rule is now set! Dates within the next 7 days from today in your selected range will be highlighted with the formatting you chose.

dates within 7 days conditional formatting google sheets

We hope that this article has helped you and given you a better understanding of how to apply conditional formatting for dates within 7 days in Google Sheets. If you enjoyed this article, you might also like our articles on how to switch to view-only mode in Google Sheets and how to swap columns in Google Sheets.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started