Hi Milo,

Am Fri, 6 Apr 2018 20:25:52 +0100 schrieb Milo Bloom:

Hello, I want to count dates if they are weekday or weekend
Col A is Dates I.E. 1 Apr 18 to 30 Apr 18
Col B is Numbers normally 65 to 200
I want to count the number of weekday and weekend in Col B

try:
=SUMPRODUCT(N(WEEKDAY(A1:A30,2)<6))
or
=SUMPRODUCT(--(WEEKDAY(A1:A31,2)<6),--(A1:A310))
for weekdays
and
=SUMPRODUCT(N(WEEKDAY(A1:A30,2)5))
or
=SUMPRODUCT(--(WEEKDAY(A1:A31,2)5),--(A1:A310))
for weekends



Regards
Claus B.
--
Windows10
Office 2016