Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.

Let’s add a conditional format that always highlights the current date: Select the cells or rows you want to highlight. In this case, select B3:E12 — the data range.

We're using a spreadsheet that includes dates of hire for employees of a fictitious company, to show different ways to format dates in Excel. 1. Highlight the date cells you want to format.