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.

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.