| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate workdays for irregular work patterns
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
|
|||
|
|||
|
Calculate workdays for irregular work patterns
Look he
http://www.cpearson.com/excel/betternetworkdays.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "Angelaf" wrote in message ... 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 | |||
| How to calculate the number of Workdays for irregular work pattern | Excel Worksheet Functions | |||
| Lost Ability To Calculate Workdays | Excel Discussion (Misc queries) | |||
| Calculate the return of irregular deposits | 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 | |||
Linear Mode
