I want to calculate only days monday - friday, without saturday and sunday. This is how it looks:
Date Numbers 1.7.2016 2354 2.7.2016 1234
When I put only one it works:
=AVERAGE(IF(WEEKDAY(B2;2)<6;D2))
But it doesn't work when I put range of, shows 0:
=AVERAGE(IF(WEEKDAY(B2:B32;2)<6;D2:D32))
I try and AVERAGEIF but give me error:
=AVERAGEIF(B2:B32;WEEKDAY(B2:B32;2)<6;D2:D32)
Bookmarks