Forum Discussion
Counting function depending on color
How to count cells according to the color of the numbers in them. Specifically those that contain black numbers. Possibly only from colorless cells.
daurel67 Then just look into using the NETWORKDAY.INTL function. It allows you to specify the days that should be counted as week-end and you can even include a list of public holidays.
Ignoring the holidays for now, the formula to count working days, with Saturday/Sunday as the week-end, for a given month could be:
=NETWORKDAYS.INTL(A1,EOMONTH(A1,0))....where A1 is the first day of the month.
Thanks. 🙂