Posted to microsoft.public.excel.worksheet.functions

Angelaf

external usenet poster

Posts: 3

How to calculate the number of Workdays for irregular work pattern

I am trying to report on the number of actual workdays between dates,
excluding weekends and Bank Holidays. I can use a modified Networkdays
formula in Excel, but only if the Work pattern is for continuous days of the
week ie: Sunday to Thursday. Problem is that we have staff on work patterns
with non-continuous days ie: Monday, Wednesday, Friday, Saturday. Any ideas
welcome.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate the return of irregular deposits	Hose	Excel Worksheet Functions	0	June 27th 06 11:15 PM
How do you calculate number of workdays from dates entered?	tfleck	Excel Worksheet Functions	1	March 25th 05 09:17 PM
How do you calculate number of workdays from dates entered?	[email protected]	Excel Worksheet Functions	0	March 25th 05 07:55 PM
Calculate the number of workdays between 2 dates	Tegid77	Excel Worksheet Functions	2	November 4th 04 11:09 PM
Calculate the number of workdays between 2 dates	Tegid77	Excel Worksheet Functions	1	November 4th 04 07:27 PM

All times are GMT +1. The time now is 10:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us