Microsoft Office Tutorials and References
In Depth Information
Working with specialized date functions
a workday, and a one (1) indicates a nonwork (weekend) day. For example, the string
"0010100" specifies Wednesdays and Fridays as your "weekend" days.
For example, the formula =NETWORKDAYS.INTL("1/1/14","2/21/15","0010100") returns the
value 297 , the number of working days between January 1, 2014 and February 21, 2015,
skipping all Wednesdays and Fridays.
Search JabSto ::

Custom Search