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

[dsrt16]

Cross posted here.

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 image, you can see they have marked Wednesday as their day off. So since there are two Wednesdays between July 8 (the K3 date) and July 21 (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.

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.

 

[alansidman]

WORKDAY.INTL Function

The Excel WORKDAY.INTL function takes a date and returns the "next" working day, based on a given offset value. Unlike the WORKDAY function, WORKDAY.INTL allows you to customize which days are considered weekends (non-working days). You can use WORKDAY.INTL function to calculate completion...

exceljet.net

 

[dsrt16]

I am not sure how to use that formula in my situation. The second condition says it is end date, but then the example formula has it linked to a cell that just says 1. Then it looks like it assigns a number to indicate what days are off (11 for Saturday only). But in my situation, a user can select what days they have off, and it will vary. Someone may have Friday, Saturday off. Someone else may have Monday, Thursday off. I have Wednesdays and Sundays off.

I need the formula to look at the day(s) of the week listed in Q4:Q6 and not count those days in the formula in cell L3 that returns the number of workdays in the date range.