3] How to create a custom-made formatting rule with dates In the above example, we navigated the steps for creating a New Rule for Conditional Formatting based on already provided criteria.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.

The LAMBDA function in Microsoft 365 Excel is a fantastic option for advanced users, empowering them to create custom, reusable functions that significantly boost productivity and precision.

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.