With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

Usually the date marks an event or the input date. Either way, counting the number of records that fall between two dates is easy using the COUNTIFS () function (which isn’t available in Excel ...

Q. I receive Excel spreadsheets regularly that contain dates. I have to manually look up the day of the week that represents these dates. Are there any functions that can help speed this process along ...

With the dates selected (C3:C37), click the Home tab, click Conditional Formatting, and then choose New Rule from the dropdown (Figure B). Excel opens the new Conditional Formatting pane to the right.