Formula to count number of days between two dates but skipping specific days of the week

So I have this formula =IF(K3="","",(IF(TODAY()>K3,M3-TODAY()+1,DAYS(M3,K3)+1))) to show the number of days between the range entered in K3 and M3. However, I also need it to not count the days off.

In the attached workbook on the scheduler page, you can see they have marked Wednesday as their day off. So since there are two Wednesdays between July 1 (the K3 date) and July 14 (the M3 date), L3 (the number of days) should show 12, as it needs to not count Wednesdays in the total days between the range, not 14. (This post was made on June 29. Since it is now past July 1, the number of days shown is no longer 14. But the concept is still the same. I need it to show the amount of days without counting whatever they list as their days off. They can have up to three).

The main goal here is to get the average number of pages they need to edit a day to finish the project on time, so it needs to reflect the accurate amount of work days they have. If they had two days off (Wednesday and Sunday), then L3 should say 10 since they have four days off in that time frame (again, it is now past July 1, so 10 is no longer the accurate number of days).

Now cross posted here.

Please see yellow banner on how to attach a sample workbook.

Try

=IF(OR($K3="",TODAY()> $M3),"",NETWORKDAYS.INTL(MAX(TODAY(),$K3),$M3,LOOKUP($Q4,{"Monday",11;"Friday",15;"Saturday",16;"Sunday",17;"Thursday",14;"Tuesday",12;"Wednesday",13})))

Post a file with an example of mutiple days off: and can there be more than one project in G3:G6 ?

If required, would a VBA solution be OK as what is required is set the NETWORkDAYS.INTL "WEEKEND" paramter as a text string indicating non-work days.

Please Login or Register  to view this content.

above code in sheet "Scheduler 2"

Please Login or Register  to view this content.

Code in Module9

Named range "Weekends" in S3

in L3

=IF(OR($K3="",TODAY()> $M3),"",NETWORKDAYS.INTL(MAX(TODAY(),$K3),$M3,weekends))

Range("Days_Off") ... "Days_Off" is a named range.

0101000: "1" indicates a non-working day and the string starts from Monday so Tuesday and Thursday are non-working days in this example.