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.
It could be what I need ...
But count my days of the week, no week-end.
But count my days of the week, no week-end.
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. 🙂
- Sometimes I have the feeling that I have to smell my fingernails to understand what everyone has in mind and not say it.
Mr. Riny_van_Eekelen thank you for the redemption.
