View Single Post
  #11   Report Post  
Milo Bloom Milo Bloom is offline
Junior Member
 
Posts: 19
Default Count Weekdays and Weekends

Ok sorry couple last problems.

I need this equation to work in Next Cells E,F,G
Keeps coming up with wrong answer

=SUMPRODUCT(--(WEEKDAY($A$2:$A$32,2)<=1),D$2:D$32)/SUMPRODUCT(N(WEEKDAY($A$2:$A$32,2)<=1))

This is for Monday and Tuesday. Seems to work for rest of days
Column A is dates starting with 29-Jul-2018 (Sunday)

Data is

L H A
56 83 65
57 79 66
55 87 68
61 85 72
57 91 74
65 87 75
62 94 77
64 87 76
60 82 70
56 87 69
57 83 69
57 87 72
62 88 75
60 90 76
61 89 75
55 88 71
58 85 70
61 87 71
59 87 72
65 87 74
58 78 69
51 73 62

This is in Column A
=IF(D24="",0,MAX($A$2:A23)+1)

Thanks