I have a worksheet that tracks labor hours imported from timesheets. It has columns for the date, employee, hours and hours type. these fields are imported. Then 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, "REG",A:A,">="&DATEVALUE("8/10/2013"),A:A,"<="&DATEVALUE("8/16/2013"),A:A,">0")

What I need to do is for the months days that have not passed yet I need to project out hours. I was hoping I could just add on to this statement Today into it and somehow have it calculate remaining hours (working days) until the end of the contract say 9/20/2013. DOes anyone have any ideas how I can do this wihtout having to add anymore unecessary data to the spreadsheet.