ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel total days formula including weekends, excluding holidays (https://www.excelbanter.com/excel-discussion-misc-queries/186491-excel-total-days-formula-including-weekends-excluding-holidays.html)

wtfisch

excel total days formula including weekends, excluding holidays
 
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.


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com