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
How to calculate difference between two date & time along with working hours and days 2
Calculate number of weeks a variable spans in 0
Count the Number of Workdays 5
Calculating number of workdays 1
How do you calculate number of workdays from dates entered? 1
How do you calculate number of workdays from dates entered? 0
Formula to Calculate # of Workdays 5

Top