Click and drag the mouse to select the column with the range of dates. Type a comma and then enter "DATE(2021, 1,15)" (do not include the quotation marks). Type a comma and then select the column ...

That covers all dates from today to seven days from now. Then change the text and background colors in the dialog. Click "Save rules" when you're done. Step 3: Enter the range of dates using the same ...

1. Type "=COUNTIF" and press the Tab key. 2. Click and drag the mouse to select the column with the range of dates. 3. Type a comma and then enter "DATE(2021, 1,15)" (do not include the quotation ...