WORKDAY.INTL in Excel 2007 to exclude Fri/Sat

Hello everyone,

My first post here, nice to meet you all.
I'm trying to solve my problem and actually close to it, missing just the last step, that's why I'd like to ask you for help.

I want to prepare a resolution time spreadsheet in Excel 2007 that shows when each team should finish their tasks within their working hours and excluding weekends.

The main part of this (working hours) is working, I just can't find a way to change the excluded weekend days from Saturday/Sunday to Friday/Saturday for some of the teams.


Here's my code as it is now:
Start time is =Now() A2 = 2/27/17 4:59 PM
Hours to add B2 in format hh:mm
End Date in date format C2

Please Login or Register  to view this content.

End Time in format hh:mm D2

Please Login or Register  to view this content.

Begin time of 1st shift (before midnight) in format hh:mm F2
End time of 1st shift (till midnight) in format hh:mm G2

+optional if shift goes through midnight
Begin time of 2nd shift (after midnight) in format hh:mm F3
End time of 2nd shift (after midnight) in format hh:mm G3
Total hours of both shifts in format hh:mm H3

Please Login or Register  to view this content.

Newer excel versions use WORKDAY.INTL function, where value 7 = Friday/Saturday as weekend, can you please help me somehow include it into my existing/working WORKDAY function?

Thank you very much, really appreciate any help with this!
Sam