With the input cells and rules in place, feel free to change the values in C1 and C2. If the value is too far into the past or into the future for the existing dates, Excel won’t apply the ...

When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells options.

Input your events into Excel. To facilitate sorting, enter the dates of your events in column A of your worksheet and the details of your events in column B.

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.

When you enter a date that's formatted with slashes, Excel will recognize it as a date. For example, Excel will automatically choose the date format for a cell that contains 11/11/19.

Now, let’s set a conditional formatting rule that highlights due dates that match the current date, which in this case is Feb. 13, 2021: Select the data. In this case, that’s C4:C8.