ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Test DataWeekend Condition DemoExpected ResultsUsing Sumproduct
2
DateDayWeekNumDayNumMarket 1Market 2Market 3Market 4Market 5Is WeekendWeekdayWeekendWeekNumWeekdaysWeekends
3
4/1/2021Thursday1455212206941054141003899Weekday891701480273934
4
4/2/2021Friday1466993511172143547104128Weekend3485615228098426
5
4/3/2021Saturday147125713744075303661393416194217970
6
4/4/2021Sunday15145312865967437731385117201929045
7
4/5/2021Monday1521266287990111214470510218187215481
8
4/6/2021Tuesday153666124696811341379053938917034856
9
4/7/2021Wednesday15495783862527883103529
10
4/8/2021Thursday1554841391700119176004526
11
4/9/2021Friday1562841452803574114604259Using Sumifs
12
4/10/2021Saturday1571039984881140426714575WeekNumWeekdaysWeekends
13
4/11/2021Sunday16111624496461060745140621480270
14
4/12/2021Monday162465145829833712270378515228093078
15
4/13/2021Tuesday16372682921910083240310616194213317
16
4/14/2021Wednesday1649818544285835750342117201923131
17
4/15/2021Thursday165128594051499114470517718187214496
18
4/16/2021Friday16631845013431156665039328917014022
19
4/17/2021Saturday167822134463747962613908
20
4/18/2021Sunday1716371499246749141214543
21
4/19/2021Monday17211371176443347104704150
22
4/20/2021Tuesday1731475955285503130104519
23
4/21/2021Wednesday174369980113226136703109
24
4/22/2021Thursday175877692536122735703689
25
4/23/2021Friday1769031254945117444904725
26
4/24/2021Saturday17759741310231454101514502
27
4/25/2021Sunday18110306151446140598515481
28
4/26/2021Monday18214651219702873105905318
29
4/27/2021Tuesday183549772937132181004389
30
4/28/2021Wednesday1841229538620800134504532
31
4/29/2021Thursday1856245921377830105904482
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100