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

If you intend to obtain a list of all dates or data between two given dates in Excel, then you can Use the Fill handle or use a Formula. Learn how.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.