How to calculate the number of Workdays for irregular work pattern

A

Angelaf

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

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate workdays for irregular work patterns 1
Formula Workdays-Holidays-adjustments 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculating number of workdays 1
Formula to Calculate # of Workdays 5
calculate number of days btw dates 2
how to count easily 21
calculating the number of consecutive shifts in a 6 week schedule 3

Top