Panopia.com

Calc Reference

Weekend Reference for WORKDAY.INTL & NETWORKDAY.INTL Functions

Saturday and Sunday 1
Sunday and Monday 2
Monday and Tuesday 3
Tuesday and Wednesday 4
Wednesday and Thursday 5
Thursday and Friday 6
Friday and Saturday 7
Sunday only 11
Monday only 12
Tuesday only 13
Wednesday only 14
Thursday only 15
Friday only 16
Saturday only 17

Another way to enter a weekend code into a parameter is using a string of ones and zeros. 0 represents a workday and 1 represents a weekend day. The string starts on Monday. For example "0000011" would indicate the weekend is Saturday and Sunday. "0000111" would indicate a 4 day workweek with Friday, Saturday and Sunday as the weekend days.

©2021 Panopia.com