Are you wanting to turn off the categories as in categories_status = 0 for every day except the current day of the week ...

Are you wanting to take, for example, today is wednesday, if the cron was to run today, at Wednesday, Midnight, do you just want the categories_status for Tuesday Category to be set to 0 for hide or don't show ... and then do you "also" need all Specials, as in Specials in the specials table deleted or set the status to 0 or what on the Products that were in the Category for Tuesday ...

I am assuming that you are using Linked Products on the Day of the Week Categories ...

Should the Products then be "removed" from the products_to_categories table that related them to the Tuesday Category ...