Countifs Blank Workdays

I have two columns, column a with data and column b with dates.

I am trying to come up with a formula to count the number of workdays in the date column (B) where the data column (A) is empty.

I know =NETWORKDAYS(B2, B10) to get the number of workdays in column b between the dates in rows 2 and 10
I know =Countif(A2:A10, "") to get the number of blank cells between A2 and A10 (or COUNTBLANK(A2:A10))
But am stumped on how to combine the two.

What do you mean "how to combine the two". BTW, it's usually best to upload a sample file as shown above in the yellow banner at the top of the page.
What are you trying to achieve?

How to combine the two queries to probably with a countifs formula to get the number of workdays which do not have any corresponding data. File loaded.

Thank you, that is awesome! But I was hoping not to need VBA and just to have a formula which would be dynamic to copy/paste and tweak the ranges as necessary.

Try this with control+shift+enter
=SUM(--IF(WEEKDAY($B$2:$B$16)<>1,IF(WEEKDAY($B$2:$B$16)<>7,($A$2:$A$16=""))))

Perfect! Thank you very much!

Originally Posted by sohaila

Try this with control+shift+enter
=SUM(--IF(WEEKDAY($B$2:$B$16)<>1,IF(WEEKDAY($B$2:$B$16)<>7,($A$2:$A$16=""))))

Perfect! Thank you very much!

Originally Posted by Bo_Ry

Please try

=SUMPRODUCT((WEEKDAY(B2:B16,2)<6)*(A2:A16=""))

Perfect! Thank you very much!

Originally Posted by Glenn Kennedy

Wrecking Crew, please amend your profile to show the Excel version(s) that you use.

...or this non-array formula (just use enter):

=SUMPRODUCT(--(WORKDAY(B2:B16-1,1)=B2:B16)*ISBLANK(A2:A16))

Perfect! Thank you very much!

Profile updated - thank you also for pointing me to do this.