Spreadsheet: 834400d1687793914-return-day-of-the-week-unless-i-want-to-return-the-entire-week-select-and-return-formula
Sheet: Sheet1

WE/WD | Weekday
Day | Wed
Month | May
Day | WD/WE | Year | Month | Day 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Mon | Weekday | 2023 | May | 2023-05-01 00:00:00 | 1.475 | -0.7624999999999993 | 0.6325000000000003 | 6.047499999999999 | 3.5175 | 4.5075 | 6.405000000000001 | 1.697499999999998 | 1.205 | 0.5874999999999986 | -3.459999999999999 | -5.215000000000002 | -4.715 | -5.079999999999998 | -3.375 | 0.1799999999999997 | -22.8775 | -102.6725 | -63.65749999999999 | -375.3724999999999 | -200.6125 | -11.1825 | 0.3574999999999982 | -2.109999999999999
Tue | Weekday | 2023 | May | 2023-05-02 00:00:00 | 2.987500000000001 | 3.592499999999999 | 1.7775 | 2.832500000000001 | 2.7525 | -2.7225 | -19.59 | -4.6525 | -24.1325 | -14 | 0.2724999999999973 | -2.16 | -1.5 | -0.8149999999999977 | -0.2025000000000006 | -4.737499999999997 | 7.1175 | -1.799999999999997 | -6.844999999999999 | -14.98500000000001 | -47.5925 | 12.93 | 2.43 | -21.075
Wed | Weekday | 2023 | May | 2023-05-03 00:00:00 | -13.02 | -8.6325 | -5.204999999999998 | -5.935000000000002 | -4.460000000000001 | 1.602499999999999 | -4.402500000000003 | 10.27 | 8.14 | 7.225 | 2.6675 | 0.6325000000000003 | 0.3024999999999984 | -6.4725 | 2.975000000000001 | 7.640000000000001 | 2.067499999999995 | -23.115 | 20.4725 | 48.5825 | 29.31 | 9.895 | 4.632499999999999 | -1.884999999999998
Thur | Weekday | 2023 | May | 2023-05-04 00:00:00 | 1.342499999999999 | -0.08750000000000036 | -1.6075 | -3.247499999999999 | -8.22 | -16.8325 | -17.465 | -8.537499999999998 | -12.7075 | -19.905 | -12.7525 | -7.65 | -2.067499999999999 | -1.607500000000002 | 2.1875 | 5.424999999999997 | 4.065000000000001 | 6.887499999999999 | -0.9775000000000027 | -262.4075 | -548.7875 | -53.80500000000001 | -17.5925 | -7.195
Fri | Weekday | 2023 | May | 2023-05-05 00:00:00 | -2.377500000000001 | 5.624999999999999 | 8.337499999999999 | 8.45 | 3.717499999999999 | 4.140000000000001 | -0.3099999999999987 | -3.859999999999999 | -8.702499999999999 | -33.8775 | -28.745 | -12.22 | -29.8075 | -14.4875 | 21.8775 | 21.09250000000001 | -12.6225 | -45.16249999999999 | -13.47 | 56.295 | 61.04249999999999 | 19.945 | 7.702499999999999 | 12.345
Sat | Weekend | 2023 | May | 2023-05-06 00:00:00 | 5.635 | 3.1325 | 6.3275 | 13.6725 | 13.0775 | 9.112499999999999 | 8.9975 | 10.4475 | 10.9825 | 13.355 | 11.6 | 10.135 | 14.3975 | 20.65 | 23.0875 | 5.775000000000006 | 29.94250000000001 | 54.545 | 33.515 | 74.32249999999999 | 55.6375 | 5.447499999999998 | -2.5275 | -1.6075
Sun | Weekend | 2023 | May | 2023-05-07 00:00:00 | -3.8125 | -4.3025 | -5.237499999999999 | -2.7425 | -2.300000000000001 | -0.6199999999999992 | 5.1275 | 3.07 | 2.77 | 0.4550000000000001 | 2.572499999999998 | 6.717499999999999 | 12.6725 | 18.5475 | 18.105 | 20.88 | 24.0175 | 20.0025 | 20.2225 | 37.9175 | 60.135 | 13.9175 | 7.2675 | 8.295
Mon | Weekday | 2023 | May | 2023-05-08 00:00:00 | 3.050000000000001 | 0.7650000000000006 | 1.82 | 1.442499999999999 | 0.7225000000000001 | 4.5 | 2.5025 | 3.727500000000001 | -0.1750000000000007 | -1.8025 | 3.295 | 3.6875 | 10.65 | 13.355 | 21.69749999999999 | 52.13000000000001 | 117.36 | 159.7925 | 60.45999999999999 | 61.47499999999999 | 41.195 | 2.4375 | 5.029999999999999 | 4.3325
Tue | Weekday | 2023 | May | 2023-05-09 00:00:00 | 1.5175 | 4.057500000000001 | 4.027500000000001 | 1.342499999999999 | -0.8050000000000015 | 2.834999999999999 | 3.852499999999999 | -4.77 | -4.965 | -6.215 | -6.425000000000001 | -5.622499999999999 | -1.840000000000003 | 3.697500000000002 | 8.934999999999999 | 9.7025 | 10.1425 | 6.2325 | 5.409999999999998 | 10.415 | 18.8675 | -0.7424999999999997 | 0.1600000000000001 | 2.717499999999999
Wed | Weekday | 2023 | May | 2023-05-10 00:00:00 | 3.2325 | 1.805 | -2.352499999999999 | -6.6775 | -7.145 | -25.615 | -20.915 | 1.862500000000001 | -3.822499999999998 | -4.637499999999999 | -1.294999999999998 | 0.007500000000000284 | -0.4500000000000011 | 3.147499999999999 | 3.9 | 5.710000000000001 | 6.012500000000001 | 7.082499999999998 | 6.229999999999999 | 11.07 | 14.725 | 0.389999999999997 | 3.034999999999998 | 2.360000000000001
Thur | Weekday | 2023 | May | 2023-05-11 00:00:00 | 2.799999999999999 | 2.177499999999998 | 0.05250000000000021 | -2.997499999999999 | -6.2775 | -1.282499999999999 | -0.3099999999999987 | -0.75 | -1.922499999999999 | -2.334999999999999 | -2.467500000000001 | 7.640000000000001 | 10.885 | 12.4025 | 4.577499999999999 | 5.397499999999999 | 3.377499999999998 | 0.01749999999999829 | -21.66 | -72.12249999999999 | -321.2975 | -128.2375 | -44.585 | -8.487499999999997
Fri | Weekday | 2023 | May | 2023-05-12 00:00:00 | -2.16 | -2.145 | -4.4575 | -4.664999999999999 | -7.282500000000001 | -4.467499999999998 | -24.4475 | -17.215 | -4.9575 | -3.3125 | -2.425000000000001 | -2.855 | -5.325000000000003 | -32.6925 | 4.029999999999998 | -13.985 | 20.5125 | 16.0375 | 13.0975 | 19.71 | 6.522500000000001 | -0.1174999999999997 | -33.1725 | -2.627500000000001
Sat | Weekend | 2023 | May | 2023-05-13 00:00:00 | 1.567499999999999 | -0.5749999999999993 | -3.510000000000002 | -3.987500000000001 | -4.7075 | -0.5899999999999999 | 1.574999999999999 | 0.202499999999997 | 1.59 | -1.585000000000001 | 2.282499999999999 | 1.725000000000001 | 2.130000000000003 | -0.1600000000000001 | -1.077500000000001 | -2.342500000000001 | 0.4525000000000006 | 2.920000000000002 | 11.155 | 0.2449999999999974 | 3.994999999999997 | -9.645000000000003 | 0.5850000000000009 | 0.6475000000000009
Sun | Weekend | 2023 | May | 2023-05-14 00:00:00 | -1.6675 | -2.835000000000001 | -3.669999999999998 | -3.862500000000001 | -4.649999999999999 | -5.3675 | -0.4075000000000024 | -0.4200000000000017 | 0.8350000000000009 | 0.002500000000001279 | 0.3500000000000014 | 2.422499999999999 | 5.779999999999998 | 3.005000000000003 | 3.352499999999999 | 4.677499999999998 | 17.425 | 27.005 | 20.9675 | 45.7025 | 28.855 | 2.344999999999999 | -0.002500000000001279 | -1.800000000000001
Mon | Weekday | 2023 | May | 2023-05-15 00:00:00 | -3.674999999999997 | -4.279999999999998 | -4.647499999999997 | -4.049999999999997 | -4.824999999999999 | -7.530000000000001 | -1.434999999999999 | 0.1074999999999982 | 0.3000000000000007 | -0.245000000000001 | -1.3675 | -1.945 | -1.4175 | 2.015000000000001 | 9.75 | 21.1875 | 26.6525 | 45.69749999999999 | 42.48 | 113.5925 | 145.7225 | 57.26499999999999 | 0.2925000000000004 | 1.100000000000001
Tue | Weekday | 2023 | May | 2023-05-16 00:00:00 | 0.7600000000000016 | -1.9025 | -2.537499999999998 | -2.232500000000002 | -2.375 | -1.834999999999997 | 6.059999999999999 | 1.697499999999998 | 2.647500000000001 | 1.439999999999998 | -1.227499999999999 | -3.702500000000001 | -7.530000000000005 | -11.9825 | -31.86 | 4.999999999999996 | 31.845 | 54.845 | 61.39749999999999 | 160.0925 | 172.9125 | 45.0375 | 2.997499999999999 | 1.614999999999998
 |  |  |  | Greater than 0
 |  |  |  | Less than 0
Jan | Mon | Weekend
Feb | Tue | Weekday
Mar | Wed
Apr | Thur
May | Fri
Jun | Sat
Jul | Sun
Aug
Sep
Oct
Nov
Dec