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.