Spreadsheet: 390277d1429579993-need-formula-to-calculate-if-date-is-within-range-calculate-if-date-is-within
Sheet: Monthly

Category 1 | Category 2 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00
Labor | Internal | 0 | 2500 | 2812.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 312.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Labor | External | 0 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 416.6666666666667 | 3988.095238095238 | 3988.095238095238 | 3571.428571428572 | 3571.428571428572 | 3571.428571428572 | 3571.428571428572 | 3571.428571428572 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hardware | Server | 0 | 0 | 0 | 0 | 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 1512.820512820513 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hardware | Maintenance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20400.36166666667 | 20400.36166666667 | 20400.36166666667 | 3733.695 | 3733.695 | 3733.695 | 3733.695 | 3733.695 | 3733.695 | 3733.695 | 0