formula for total days, excluding holidays but including weekends

W

wtfisch

I need a formula to calculate total days (working days) that excludes
holidays, but includes weekends. The networkdays formula doesn't work since
we work on weekends and have variable days off. I wanted to put the select
days off( some weekdays and some weekends in a holiday range), and have them
subtracted from the start date, end date range if they fall in the range.
 
T

T. Valko

Try this...

List off dates and holiday dates in a range of cells, say, H1:H10

A1 = start date
B1 = end date

=B1-A1+1-MEDIAN(FREQUENCY(H1:H10,A1:B1-{1,0}))

Format as General or Number
 

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

Help 2
Conditional formatting excluding weekends and holidays 1
Date Calculation Formula- Calendar days minus Holidays 1
vacation excluding holidays 1
Date + X days excluding holidays 1
Annual leave without holidays 3
Calculate End Date (excluding weekends and holidays) 6
Calculate work days 3

Top