Conditional Formatting If Statement Using Dates in Excel

Conditional Formatting If Statement Using Dates in Excel

I have a spreadsheet set up in Excel (shown below) with a date column called Appointment Date. I want to highlight all of the dates in that column but only IF they fall within the next 7 days. Firstly, we need to know what today’s date is to be able to carry out...