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.
|