Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December.

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 ...

Similarly, you can assign a day of the week (converting 1-7 numerical to weekday) and even turn product code into a category using the SWITCH function.