greyjester
New Member
- Joined
- Mar 4, 2009
- Messages
- 2
I am trying to develop a formula that will allow me to calculate the number of work days for work weeks with different begin/end dates. For example, it is easy to use the networkdays functions to calculate the number of monday-friday work days for the period Jan 1-15 2009.
However, if I have an overseas work week that runs Sunday-Thursday, how can I modify the networkdays formula to return the number of workdays that follows that work week? I also have work weeks that run Saturday-Wednesday that need the same problem solved.
I am a complete loss as how to continue and need a repeatable formula so I am not dragging out a calendar and manually counting days each time I need to recreate this process.
Any help that could be provided would be greatly appreciated.
Greyjester
However, if I have an overseas work week that runs Sunday-Thursday, how can I modify the networkdays formula to return the number of workdays that follows that work week? I also have work weeks that run Saturday-Wednesday that need the same problem solved.
I am a complete loss as how to continue and need a repeatable formula so I am not dragging out a calendar and manually counting days each time I need to recreate this process.
Any help that could be provided would be greatly appreciated.
Greyjester