To highlight weekend dates, we’ll use the WEEKDAY () function in a conditional formatting rule. This function returns a number between 1 and 7 to identify the day of the week, as a date.

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...