I use Excel quite a bit but am not the greatest at formulas. I'm inserting an image of what my data looks like and I'll describe what I want to accomplish.

First, I need Excel to look at the day of the week and time of day to determine if its an on/off peak day and an on/off peak time of day. 11 p.m. to 7 a.m., Monday through Saturday is always off peak, and then Sunday all day is off peak. Also, we have 5 or 6 holidays (I'd have to look at rate schedule to see what they are) that are off peak. What do I need to do to calculate this on ever cell, so at the beginning of each month, I'm not manually moving my formulas around to the correct days of the week?

Sorry if I'm not making my questions clear. Hopefully someone is familiar with what I'm trying to do. I tried to search the forums for something like this, but not sure what to look for. Please point me in the right direction if its already answered.

Thanks in advance!! Below is the image!

Column D and E sum up the KWH (column B) down to that point and then I add all those up at the bottom. D and E have those formulas at the end of each on/off peak. They add up the previous time period's KWH. If it would be better for me to attach the working document, I can create a non-sensitive copy.

TOU Data Calculation.jpg