excel total days formula including weekends, excluding holidays

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.
 

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

formula for total days, excluding holidays but including weekends 3
Date + X days excluding holidays 1
Conditional formatting excluding weekends and holidays 1
vacation excluding holidays 1
Annual leave without holidays 3
Date Calculation Formula- Calendar days minus Holidays 1
Date Formula Excluding Weekends 3
Find last day of month depending on criteria 12

Top