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...
Top 5 Ways to Use Percentages in Excel

Top 5 Ways to Use Percentages in Excel

How To Work Out Percentages in Excel  tax percentages, percentage change, percentage increase, percentage of total…. Whenever I’m delivering an introductory Excel course, one of the core topics I cover is percentages. It’s a basic skill that crops up...