Schedule shift for holiday

[djay1991]

I have a fleet of truck I'm tracking. I need a minimum amount of trucks every day, depending on the day of the week. Right now I am using nested "IF" statements checked against a cell that has the date in it to pull trucks needed number. I have two questions. First I want to be able to shift everything 1 day for holidays. Sometime observed holiday will be different then the actual holiday. Second, is there a better way then nested IF to do this?

 

[Legacy 143009]

Can you share sample table? May be there can be done something with INDEX() and MATCH() functions.

 

[djay1991]

Here's a link. Under the "Totals" and "ES Report" sheet I pull the required number from the "Count" sheet. I use the date on the sheet to set the day of the week which then gets my count number. I need a way, preferably automatically, to shift everything one day from the holiday through the week then the next week go back to original.


https://drive.google.com/file/d/1OlUL6-jjMajeoHrx1h7IppltdgSJbxAw/view?usp=sharing