Yes that is sort of what I want but what I am looking for is a formula that is sort of like a if then statement or calculation that says

if it is after todays date then put however many hours is left between now until sept. 20th 2013 otherwise sum the total hours in column C:C that has the name "Jack" in column B:B that has the pay type "REG" in column D that falls under the dates 8/1/2013 in column A:A and Date 8/2/2013 in column A:A. So on and so forth for each column in my spreadsheet.



Right now I have my spreadsheet to where I manually have to go in there and and add 40 hours or however many hours are in each date range remaining and then as each date range passes I remove that amount of hours I would like to not have to do this because it leaves room for errors and leaves room for me to forget to go in and manually do something and then my $$ money numbers will be off and that is never good.

I hope that better explains what I am looking for

Ok, so you need three things. The first you had before we started:The second is the function I found for you:That's the NETWORKDAYS function. I've never used it myself, but you shouldn't have any trouble figuring it out from the documentation.

The only part that's left, if I understand you correctly, is an IF function to decide which value to display. You know how IF works, right? You just need to say =IF(cell>TODAY(),NETWORKDAYS(arguments),SUMIFS(arguments)). Or of course you can put =NETWORKDAYS and =SUMIFS in separate helping columns and then have your IF function refer to them there.

Ah!!! I was just doing it backwards... I was trying to put the If statement in my SumIFS statement. I will try this and see if I can get it to work. I have been having trouble with the syntax (which is always my problem) I do not have a very logical mind and am so thankful for these websites where people like you are so helpful.

Can the =If(cell>TODAY()
look at a date range that is in just one cell? that is what is in one cell or should I break those into seperate cells as a start date and end date of the date ranges?

The problem is I cannot change the format too much on the spreadsheet because it is my bosses and I am trying to keep it as close to his format as possible so that he can look at it an understand what is going on.