Spreadsheet: 689594d1596543350-how-to-apply-date-range-to-if-formula-test
Sheet: 04 - Go Live Data

 | Project | Reporting Month | Go Live Reported | [NAME] |  | Projects On Time | On Time vs Original Forecast
 | Project A-01 | Apr | 2020-07-01 00:00:00 |  |  | Apr
 | Project A-02 | Apr | 2020-11-01 00:00:00 |  |  | May
 | Project A-03 | Apr | 2021-01-01 00:00:00 |  |  | Jun
 | Project A-04 | Apr | 2020-03-01 00:00:00 |  |  | Jul
 | Project A-05 | Apr | 2020-03-01 00:00:00 |  |  | Aug
 | Project A-06 | Apr | 2020-05-01 00:00:00 |  |  | Sep
 | Project A-07 | Apr | 2020-08-01 00:00:00 |  |  | Oct
 | Project A-08 | Apr | 2020-05-01 00:00:00 |  |  | Nov
 | [NAME] | Apr | 2020-07-01 00:00:00 |  |  | Dec
 | Project B-02 | Apr | 2020-09-01 00:00:00 |  |  | Jan
 | Project B-03 | Apr | 2020-06-01 00:00:00 |  |  | Feb
 | Project B-04 | Apr | 2020-06-01 00:00:00 |  |  | Mar
 | Project B-05 | Apr | 2020-05-01 00:00:00
 | Project B-06 | Apr | 2020-01-01 00:00:00
 | Project B-07 | Apr | 2020-04-01 00:00:00
 | Project B-08 | Apr | 2020-09-01 00:00:00
 | Project C-01 | Apr | 2020-03-01 00:00:00
 | Project C-02 | Apr | 2020-04-01 00:00:00
 | Project C-03 | Apr | 2020-06-01 00:00:00
 | Project C-04 | Apr | 2020-06-01 00:00:00
 | Project C-05 | Apr | 2021-03-01 00:00:00
 | Project C-06 | Apr | 2020-05-01 00:00:00
 | Project A-01 | May | 2020-09-01 00:00:00
 | Project A-02 | May | 2021-04-01 00:00:00
 | Project A-03 | May | 2021-01-01 00:00:00
 | Project A-04 | May | 2020-03-01 00:00:00
 | Project A-05 | May | 2020-07-01 00:00:00
 | Project A-06 | May | 2020-05-01 00:00:00
 | Project A-07 | May | 2020-09-01 00:00:00
 | Project A-08 | May | 2020-07-01 00:00:00
 | [NAME] | May | 2020-07-01 00:00:00
 | Project B-02 | May | 2020-10-01 00:00:00
 | Project B-03 | May | 2020-09-01 00:00:00
 | Project B-04 | May | 2020-09-01 00:00:00
 | Project B-05 | May | 2020-10-01 00:00:00
 | Project B-06 | May | 2020-01-01 00:00:00
 | Project B-07 | May | 2021-01-01 00:00:00
 | Project B-08 | May | 2021-07-01 00:00:00
 | Project C-01 | May | 2020-03-01 00:00:00
 | Project C-02 | May | 2020-03-01 00:00:00
 | Project C-03 | May | 2020-06-01 00:00:00
 | Project C-04 | May | 2020-10-01 00:00:00
 | Project C-05 | May | 2021-03-01 00:00:00
 | Project C-06 | May | 2020-05-01 00:00:00
 | Project A-01 | Jun | 2020-09-01 00:00:00
 | Project A-02 | Jun | 2021-04-01 00:00:00
 | Project A-03 | Jun | 2021-01-01 00:00:00
 | Project A-04 | Jun | 2020-03-01 00:00:00
 | Project A-05 | Jun | 2020-07-01 00:00:00
 | Project A-06 | Jun | 2020-05-01 00:00:00
 | Project A-07 | Jun | 2020-09-01 00:00:00
 | Project A-08 | Jun | 2021-03-01 00:00:00
 | [NAME] | Jun | 2020-07-01 00:00:00
 | Project B-02 | Jun | 2020-10-01 00:00:00
 | Project B-03 | Jun | 2020-09-01 00:00:00
 | Project B-04 | Jun | 2020-09-01 00:00:00
 | Project B-05 | Jun | 2020-10-01 00:00:00
 | Project B-06 | Jun | 2020-01-01 00:00:00
 | Project B-07 | Jun | 2021-01-01 00:00:00
 | Project B-08 | Jun | 2021-07-01 00:00:00
 | Project C-01 | Jun | 2020-03-01 00:00:00
 | Project C-02 | Jun | 2020-05-01 00:00:00
 | Project C-03 | Jun | 2020-06-01 00:00:00
 | Project C-04 | Jun | 2020-10-01 00:00:00
 | Project C-05 | Jun | 2021-03-01 00:00:00
 | Project C-06 | Jun | 2020-05-01 00:00:00
 | Project A-01 | Jul | 2020-09-01 00:00:00
 | Project A-02 | Jul | 2021-04-01 00:00:00
 | Project A-03 | Jul | 2021-01-01 00:00:00
 | Project A-04 | Jul | 2020-03-01 00:00:00
 | Project A-05 | Jul | 2020-07-01 00:00:00
 | Project A-06 | Jul | 2020-05-01 00:00:00
 | Project A-07 | Jul | 2020-09-01 00:00:00
 | Project A-08 | Jul | 2021-03-01 00:00:00
 | [NAME] | Jul
 | Project B-02 | Jul | 2020-08-01 00:00:00
 | Project B-03 | Jul
 | Project B-04 | Jul
 | Project B-05 | Jul
 | Project B-06 | Jul | 2020-01-01 00:00:00
 | Project B-07 | Jul | 2021-01-01 00:00:00
 | Project B-08 | Jul | 2021-07-01 00:00:00
 | Project C-01 | Jul | 2020-03-01 00:00:00
 | Project C-02 | Jul | 2020-05-01 00:00:00
 | Project C-03 | Jul | 2020-06-01 00:00:00
 | Project C-04 | Jul | 2020-10-01 00:00:00
 | Project C-05 | Jul | 2021-03-01 00:00:00
 | Project C-06 | Jul | 2020-05-01 00:00:00