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.

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.