Changing % Formula to COUNT

[vill]

Hi guys, would you mind taking a look at a formula, as per Excel attached? Its a formula that currently does an excellent job adapting to changing weeks with every new month selected (life saving formula!), and returning results in %.

However, now trying to make use of same (or similar) formula to do the COUNT only, while STILL keeping the adapting to changing weeks feature available (a must!)

Is there a way of using this same formula/approach, but only to return COUNT instead of % results?

Unless the current way does not apply to COUNT only, I'd think making use of existing formula would be easiest way going around this challenge, instead of trying to recreate something new.

Below are the Excel and a screenshot. Would you be okay to taking a look at it, please? Thanking in advance!

https://www.excelforum.com/attachmen...1&d=1509630011

2017-11-02_1529.png

[JohnTopley]

Try

=IFERROR(COUNTIFS(INDEX($C7:$AG7,DAY(WORKDAY.INTL($C$4-1,RIGHT(C$9,1)-1,"1111110")+1)):INDEX($C7:$AG7,DAY(MIN(WORKDAY.INTL($C$4-1,RIGHT(C$9,1),"1111110"),EOMONTH($C$4,0)))),"Y"),0)

[vill]

Brilliant, sir! Works-a-magic :-) Thank you so muc!!