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.