Timesheet Networkday help

[ismailshajji]

Hello Guys,

I think this is my final amendment to my timesheet
I would like to see if it is possible to have a formula where in if an employee selects No for a mon/tues or wed/thu,etc.. on sheet 2 as a he doesnt work on a monday or any day of his choice then the network day formula (F37-September 19)does not calculate these as a working days.

I have attached the sheet that i have developed so far .

Thank you so much for your help.

Regards,

[Glenn Kennedy]

Use this:

=NETWORKDAYS.INTL($A$5,$A$34,"1000011")*7.5/24

The 1000011 first digit is Monday, 1=Not working, 0 = working. So this is Tue-Fri, inclusive, working days.

[ismailshajji]

Use this:

=NETWORKDAYS.INTL($A$5,$A$34,"1000011")*7.5/24

The 1000011 first digit is Monday, 1=Not working, 0 = working. So this is Tue-Fri, inclusive, working days.

Hello Glenn,
Thank you so much for your prompt response.
our staff has various days off some works mon to friday some from Tue to Friday and so on my idea was to give employees an option to choose at the initial stage their contracted days and based upon their selection Networkday function or any other excel function to calculate days.

Regards.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.