Calculate workdays for irregular work patterns

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.
 

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

How to calculate the number of Workdays for irregular work pattern 1
Search closest day in the past from today 2
Formula Workdays-Holidays-adjustments 4
Pls Help - blank cell/formula issue 7
Calculate number of weeks a variable spans in 0
UK Business Days Formula 1
Work days 6
Formulaes 1

Top