Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.

As well as adding days to a date, you can also use a similar principle to subtract days from a date. For example, you might want to work out what the date was 35 days before July 1, 2025. In cell ...

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.

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.