Count NetWorkdays + Saturday

[Mudbutt]

I have a dynamic name range for my dates in the current month and I want a formula that calculates the number or working days within the month including saturdays. Because it is a dynamic range, I'm trying to do this using the name range ("Dates"), instead of a first and last date formula via networkdays.

Is there a way to do this with COUNTIF?

 

[Marcelo Branco]

Maybe something like this

=SUMPRODUCT(--(WEEKDAY(Dates)<>1),--ISNA(MATCH(Dates,Holydays,0)))

assuming you also have a named-range = Holydays

M.

 

[Mudbutt]

Thanks, works great.

 

[Marcelo Branco]

Thanks, works great.

You are welcome and tks for the feedback

M.