How to use Microsoft 365’s dynamic array function SEQUENCE () to create a list of dates in Excel Published August 24, 2021 Written by Susan Harkins ...

About the WEEKDAY () function To highlight weekend dates, we’ll use the WEEKDAY () function in a conditional formatting rule.

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