Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate the number of Workdays for irregular work pattern
I have a formula at
http://www.cpearson.com/excel/betternetworkdays.aspx that will do exactly what you want. It allows you to specify anywhere between 0 and 7 days of the week (including non-consecutive days) to omit from the calculation. It also supports a holiday list, just as NETWORKDAYS does. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Mon, 27 Jul 2009 13:51:01 -0700, Angelaf wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the return of irregular deposits | Excel Worksheet Functions | |||
How do you calculate number of workdays from dates entered? | Excel Worksheet Functions | |||
How do you calculate number of workdays from dates entered? | Excel Worksheet Functions | |||
Calculate the number of workdays between 2 dates | Excel Worksheet Functions | |||
Calculate the number of workdays between 2 dates | Excel Worksheet Functions |