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. I know how much time I used to waste on tedious Excel ...