View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angelaf Angelaf is offline
external usenet poster
 
Posts: 3
Default 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.