Ok, so you need three things. The first you had before we started:
Quote:
I have columns where each week period there is a calculation to calculate the total hours for each individual for that week period. That looks like this....
=SUMIFS(C:C,B:B,"Smith",D:D, "REG",A:A,">="&DATEVALUE("8/10/2013"),A:A,"<="&DATEVALUE("8/16/2013"),A:A,">0")
|
The second is the function I found for you:
Quote:
|
....put however many hours is left between now until sept. 20th 2013....
|
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.