You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

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

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.

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.