I want to count cells, whose values are dates, under the following condition: The date value entered must be a day between Monday and Friday.
Assume the following data and my try:
Column A -- 15.01.2015 (5) 16.01.2015 (6) 17.01.2015 (7) 18.01.2015 (1) 19.01.2015 (2)
WEEKDAY seems to be practical to use. It returns
1 for a Monday through
7 for a Sunday.
=COUNTIF( A:A; WEEKDAY(A:A; 1) < 6 )
For now my formula returns
3 is expected.
How can I change it to the right behavior?