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?