Spreadsheet: 854866d1704619716-formula-or-function-to-compare-dates-and-calculate-relevant-cells-matchday
Sheet: Filter_Min_Pts_Rtg

 |  | Min Pts Rtg | 5.7 |  | Min Pts Rtg |  | 8.5
Date Ov | Rtg_1 | Rtg_2 | PtsOv | Rtg_3 | Rtg_4 | [NAME] | PtsUn | Date Un
2023-11-19 00:00:00 | 0.0246767775757688 | 0.030781012157459 | 6.029999999999999 | -65.5944886700319 | -32.6603692013581 | -8.85 | 9.8 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 0.0269129871960894 | 0.0314424894386781 | 6.77 | -60.5835461573789 | -26.6283873601177 | -10.52 | 11.87 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 0.0270964353901937 | 0.0315473055056477 | 6.300000000000001 | -58.50167242313 | -26.2935362150981 | -8.899999999999999 | 9.96 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 0.0279910971017257 | 0.0317961500335354 | 6.630000000000001 | -57.7481820856055 | -25.6931771122265 | -10.76 | 12.28 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 0.0298791809471662 | 0.0338047973064364 | 5.980000000000001 | -56.5438927029129 | -25.5954271147424 | -10.98 | 12.28 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.04086786175368 | 5.87994680356143 | 6.87 | -56.1003632268527 | -24.4355153918019 | -9.47 | 10.6 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.06020760616815 | 5.90900729302491 | 8.45 | -55.5051096507779 | -20.1616759272152 | -7.73 | 8.569999999999999 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.17251785219625 | 5.9486813134631 | 6.510000000000001 | -44.0081153289938 | -18.6259549782001 | -8.26 | 8.51 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.18006827996755 | 5.98067688497127 | 6.56 | -35.7820172010716 | -15.6422006054627 | -9.77 | 9.06 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.24205562857335 | 6.0333179437634 | 6.83 | -12.8096510043064 | -6.36162217028164 | -9 | 8.879999999999999 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.28800980326586 | 6.03561934603972 | 8.74 | -10.7057373753229 | -5.78005581395727 | -10.48 | 10.3 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.37979861210856 | 6.05609204826394 | 8.760000000000002 | -8.81148201374806 | -4.02128810488572 | -8.25 | 8.509999999999998 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.42551200431594 | 6.06557052109788 | 10.47 | 0.00946001669899249 | 0.0104541260205725 | -10.91 | 9.040000000000001 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.4271919639439 | 6.19085681460003 | 9.11 | 0.268849369519696 | 0.330482461653588 | -11.08 | 9.62 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.44279666907863 | 6.22288310298744 | 8.86 | 0.287701542276723 | 0.345593239847921 | -10.17 | 9.129999999999999 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.61706860427411 | 6.36156528867836 | 8.84 | 0.290170377452122 | 0.346754724197763 | -10.17 | 9.469999999999999 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.72678408413231 | 6.36446985101516 | 6.949999999999999 | 0.290679734483737 | 0.348603297576151 | -9.870000000000001 | 9.469999999999999 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.74027546935454 | 6.37499866498724 | 6.91 | 0.292387564503329 | 0.353984371111122 | -9.870000000000001 | 9.329999999999998 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 5.87994680356143 | 6.45876541499761 | 6.61 | 1.09013226242067 | 1.2850539924325 | -11.43 | 9.19 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 161.831590755975 | 265.529545705371 | 7.08 | 1.42806478416724 | 1.68377093008418 | -7.84 | 8.819999999999999 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 162.837672882 | 307.722395902626 | 6.960000000000002 | 1.54301364642445 | 1.76551623827457 | -10.78 | 9.699999999999998 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 171.832549634673 | 327.628775248399 | 6.960000000000002 | 2.86094543181556 | 3.09468691085358 | -8.370000000000001 | 8.650000000000002 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 172.890216025658 | 337.263900350038 | 6.9 | 2.86134108111637 | 3.13871260725001 | -8.370000000000001 | 8.53 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 175.463297343075 | 343.594634717959 | 6.699999999999999 | 2.88996626070159 | 3.19251323378722 | -8.6 | 8.700000000000001 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 175.738590948851 | 343.662834949429 | 6.95 | 2.9603937555827 | 3.36284804752909 | -9.83 | 11.26 | 2023-11-19 00:00:00
2023-11-19 00:00:00 | 180.254143706531 | 369.041159342305 | 7.02 | 2.96893261822094 | 3.4124703224033 | -9.83 | 11.66 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 0.00125319566408305 | 0.00148204753674954 | 5.869999999999999 | 2.98001696271119 | 3.44555707075414 | -10.15 | 11.66 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 0.0246767775757688 | 0.030781012157459 | 6.029999999999999 | 3.02673982518628 | 3.49389900235456 | -10.15 | 11.69 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 0.0269129871960894 | 0.0314424894386781 | 6.77 | 3.03828289020183 | 3.53356492084549 | -7.99 | 9.780000000000001 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 0.0270964353901937 | 0.0315473055056477 | 6.300000000000001 | 3.08037788327838 | 3.68963461917041 | -8.25 | 10.41 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 0.0279910971017257 | 0.0317961500335354 | 6.630000000000001 | 10.9191950056957 | 13.2050908562869 | -10.68 | 9.34 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 0.0298791809471662 | 0.0338047973064364 | 5.980000000000001 | 10.9809430092148 | 13.2085941828624 | -10.82 | 9.34 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 5.04086786175368 | 5.87994680356143 | 6.87 | 11.0101060494515 | 13.2292482495248 | -10.62 | 9.34 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 5.06020760616815 | 5.90900729302491 | 8.45 | 16.0136633724417 | 19.1023353251261 | -7.15 | 8.92 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 5.17251785219625 | 5.9486813134631 | 6.510000000000001 | 27.9303416105562 | 31.8778118357797 | -6.03 | 10.21 | 2023-11-19 00:00:00
2023-11-20 00:00:00 | 5.18006827996755 | 5.98067688497127 | 6.56 | -73.2505218388611 | -32.6603692013581 | -9.129999999999999 | 9.799999999999999 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.24205562857335 | 6.0333179437634 | 6.83 | -65.5944886700319 | -26.6283873601177 | -10.82 | 11.87 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.28800980326586 | 6.03561934603972 | 8.74 | -60.5835461573789 | -26.2935362150981 | -10.87 | 11.87 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.37979861210856 | 6.05609204826394 | 8.760000000000002 | -58.50167242313 | -25.6931771122265 | -10.87 | 12.28 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.42551200431594 | 6.06557052109788 | 10.47 | -57.7481820856055 | -25.5954271147424 | -11.34 | 12.28 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.4271919639439 | 6.19085681460003 | 9.11 | -56.1003632268527 | -24.4355153918019 | -11.44 | 12.28 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.44279666907863 | 6.22288310298744 | 8.86 | -55.5051096507779 | -20.1616759272152 | -9.7 | 10.6 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.61706860427411 | 6.36156528867836 | 8.84 | -53.0229503146704 | -19.6068048283422 | -8.26 | 8.569999999999999 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.72678408413231 | 6.36446985101516 | 6.949999999999999 | -44.0081153289938 | -18.6259549782001 | -8.26 | 8.51 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.74027546935454 | 6.37499866498724 | 6.91 | -35.7820172010716 | -15.6422006054627 | -9.77 | 9.06 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 5.87994680356143 | 6.45876541499761 | 6.61 | -12.8096510043064 | -6.36162217028164 | -9 | 8.879999999999999 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 161.831590755975 | 265.529545705371 | 7.08 | -10.7057373753229 | -5.78005581395727 | -10.48 | 10.3 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 162.837672882 | 307.722395902626 | 6.960000000000002 | -8.81148201374806 | -4.02128810488572 | -8.25 | 8.509999999999998 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 171.832549634673 | 327.628775248399 | 6.960000000000002 | 0.268849369519696 | 0.330482461653588 | -11.08 | 9.62 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 172.890216025658 | 337.263900350038 | 6.9 | 0.282458202618127 | 0.345593239847921 | -11.08 | 9.129999999999999 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 175.463297343075 | 343.594634717959 | 6.699999999999999 | 0.287701542276723 | 0.346754724197763 | -12.77 | 11.03 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 175.738590948851 | 343.662834949429 | 6.95 | 0.290170377452122 | 0.348603297576151 | -10.69 | 9.469999999999999 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 180.254143706531 | 369.041159342305 | 7.02 | 0.290679734483737 | 0.353984371111122 | -12.47 | 10.89 | 2023-11-20 00:00:00
2023-11-20 00:00:00 | 691.259837939229 |  | 5.749999999999999 | 0.292387564503329 | 0.356037413725256 | -10.84 | 9.329999999999998 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 0.0246767775757688 | 0.030781012157459 | 6.029999999999999 | 0.298607933337276 | 0.373077554567794 | -10.84 | 9.519999999999998 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.04086786175368 | 5.87994680356143 | 6.87 | 1.09013226242067 | 1.2850539924325 | -11.43 | 9.19 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.06020760616815 | 5.90900729302491 | 8.45 | 1.42806478416724 | 1.69142264335716 | -7.84 | 8.6 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.17251785219625 | 5.9486813134631 | 6.510000000000001 | 2.86094543181556 | 3.09468691085358 | -8.370000000000001 | 8.650000000000002 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.18006827996755 | 5.98067688497127 | 6.56 | 2.86134108111637 | 3.13871260725001 | -8.370000000000001 | 8.53 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.24205562857335 | 6.0333179437634 | 6.83 | 2.88996626070159 | 3.19251323378722 | -8.6 | 8.700000000000001 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.28800980326586 | 6.03561934603972 | 8.74 | 2.9603937555827 | 3.36284804752909 | -9.83 | 11.26 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.37979861210856 | 6.05609204826394 | 8.760000000000002 | 2.96893261822094 | 3.4124703224033 | -9.83 | 11.66 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.42551200431594 | 6.06557052109788 | 10.47 | 2.98001696271119 | 3.44555707075414 | -10.15 | 11.66 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.4271919639439 | 6.19085681460003 | 9.11 | 3.02673982518628 | 3.49389900235456 | -10.15 | 11.69 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.44279666907863 | 6.22288310298744 | 8.86 | 3.03828289020183 | 3.53356492084549 | -7.99 | 9.780000000000001 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.61706860427411 | 6.36156528867836 | 8.84 | 3.08037788327838 | 3.68963461917041 | -8.25 | 10.41 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.72678408413231 | 6.36446985101516 | 6.949999999999999 | 10.9191950056957 | 13.2050908562869 | -10.68 | 9.34 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.74027546935454 | 6.37499866498724 | 6.91 | 10.9809430092148 | 13.2085941828624 | -10.82 | 9.34 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 5.87994680356143 | 6.45876541499761 | 6.61 | 11.0101060494515 | 13.2292482495248 | -10.62 | 9.34 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 161.831590755975 | 265.529545705371 | 7.08 | 16.0136633724417 | 19.1023353251261 | -7.15 | 8.92 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 162.837672882 | 307.722395902626 | 6.960000000000002 | 27.6064348869942 | 31.8778118357797 | -5.62 | 10.21 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 171.832549634673 | 327.628775248399 | 6.960000000000002 | 27.9303416105562 | 31.9619637651369 | -5.86 | 10.21 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 172.890216025658 | 337.263900350038 | 6.9 | 29.4180645655377 | 32.8195135464559 | -6.02 | 10.47 | 2023-11-20 00:00:00
2023-11-21 00:00:00 | 175.463297343075 | 343.594634717959 | 6.699999999999999 | -69.3450806259063 | -32.6603692013581 | -8.870000000000001 | 9.799999999999999 | 2023-11-21 00:00:00
2023-11-21 00:00:00 | 175.738590948851 | 343.662834949429 | 6.95 | -65.5944886700319 | -27.58340130464 | -10.54 | 12.15 | 2023-11-21 00:00:00
2023-11-21 00:00:00 | 180.254143706531 | 369.041159342305 | 7.02 | -60.5835461573789 | -26.6283873601177 | -10.54 | 12.31 | 2023-11-21 00:00:00
 |  |  |  | -58.50167242313 | -26.2935362150981 | -10.78 | 12.31 | 2023-11-21 00:00:00
 |  |  |  | -57.7481820856055 | -25.6931771122265 | -12.73 | 14.63 | 2023-11-21 00:00:00
 |  |  |  | -56.1003632268527 | -25.5954271147424 | -12.95 | 14.63 | 2023-11-21 00:00:00
 |  |  |  | -55.5051096507779 | -24.4355153918019 | -11.44 | 12.95 | 2023-11-21 00:00:00
 |  |  |  | -53.0229503146704 | -20.1616759272152 | -9.7 | 10.92 | 2023-11-21 00:00:00
 |  |  |  | -44.0081153289938 | -19.6068048283422 | -8.26 | 8.67 | 2023-11-21 00:00:00
 |  |  |  | -10.7057373753229 | -5.78005581395727 | -10.48 | 10.3 | 2023-11-21 00:00:00
 |  |  |  | -8.81148201374806 | -4.02128810488572 | -8.25 | 8.509999999999998 | 2023-11-21 00:00:00
 |  |  |  | 0.00919344403771204 | 0.0103800840158671 | -10.34 | 9.18 | 2023-11-21 00:00:00
 |  |  |  | 0.00923163122334262 | 0.0104203348743363 | -10.91 | 9.18 | 2023-11-21 00:00:00
 |  |  |  | 0.268849369519696 | 0.330482461653588 | -11.08 | 9.62 | 2023-11-21 00:00:00
 |  |  |  | 0.282458202618127 | 0.345593239847921 | -11.08 | 9.129999999999999 | 2023-11-21 00:00:00
 |  |  |  | 0.287701542276723 | 0.346754724197763 | -12.77 | 11.03 | 2023-11-21 00:00:00
 |  |  |  | 0.290170377452122 | 0.348603297576151 | -10.69 | 9.469999999999999 | 2023-11-21 00:00:00
 |  |  |  | 0.290679734483737 | 0.353984371111122 | -12.47 | 10.89 | 2023-11-21 00:00:00
 |  |  |  | 0.292387564503329 | 0.356037413725256 | -10.84 | 9.329999999999998 | 2023-11-21 00:00:00
 |  |  |  | 0.298607933337276 | 0.373077554567794 | -10.84 | 9.519999999999998 | 2023-11-21 00:00:00
 |  |  |  | 1.09013226242067 | 1.2850539924325 | -11.43 | 9.19 | 2023-11-21 00:00:00
 |  |  |  | 2.86094543181556 | 3.09468691085358 | -8.370000000000001 | 8.650000000000002 | 2023-11-21 00:00:00
 |  |  |  | 2.86134108111637 | 3.13871260725001 | -8.370000000000001 | 8.53 | 2023-11-21 00:00:00
 |  |  |  | 2.88996626070159 | 3.19251323378722 | -8.6 | 8.700000000000001 | 2023-11-21 00:00:00
 |  |  |  | 2.9603937555827 | 3.36284804752909 | -9.83 | 11.26 | 2023-11-21 00:00:00
 |  |  |  | 2.96893261822094 | 3.4124703224033 | -9.83 | 11.66 | 2023-11-21 00:00:00
 |  |  |  | 2.98001696271119 | 3.44555707075414 | -10.15 | 11.66 | 2023-11-21 00:00:00
 |  |  |  | 3.02673982518628 | 3.49389900235456 | -10.15 | 11.69 | 2023-11-21 00:00:00
 |  |  |  | 3.03828289020183 | 3.53356492084549 | -7.99 | 9.780000000000001 | 2023-11-21 00:00:00
 |  |  |  | 10.9191950056957 | 13.2050908562869 | -10.68 | 9.34 | 2023-11-21 00:00:00
 |  |  |  | 10.9809430092148 | 13.2085941828624 | -10.82 | 9.34 | 2023-11-21 00:00:00
 |  |  |  | 11.0101060494515 | 13.2292482495248 | -10.62 | 9.34 | 2023-11-21 00:00:00
 |  |  |  | 27.6064348869942 | 31.6901894472755 | -5.62 | 9.719999999999999 | 2023-11-21 00:00:00
 |  |  |  | 27.9303416105562 | 31.8778118357797 | -7.640000000000001 | 12.22 | 2023-11-21 00:00:00
 |  |  |  | 28.0682632100217 | 31.9619637651369 | -5.86 | 10.19 | 2023-11-21 00:00:00
 |  |  |  | 29.4180645655377 | 32.5368923960707 | -6.02 | 10.19 | 2023-11-21 00:00:00
 |  |  |  | 29.4361469902987 | 32.8195135464559 | -6.02 | 10.36 | 2023-11-21 00:00:00