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

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.