Spreadsheet: 747586d1631605197-date-difference-multiple-entries-in-rows-example
Sheet: Sheet1

Asset | Month, Year | Last Collected Measurement | Latest Date | Latest Date | Data Plot | Difference Between last collected and previous collected date | Upcoming | Overdue
118737 | Aug '20 |  | 2021-09-09 00:00:00
118737 | Sep '20 |  | 2021-09-09 00:00:00
118737 | Oct '20 |  | 2021-09-09 00:00:00
118737 | Nov '20 |  | 2021-09-09 00:00:00
118737 | Dec '20 |  | 2021-09-09 00:00:00
118737 | Jan '21 |  | 2021-09-09 00:00:00
118737 | Feb '21 |  | 2021-09-09 00:00:00
118737 | Mar '21 |  | 2021-09-09 00:00:00
118737 | Apr '21 |  | 2021-09-09 00:00:00
118737 | May '21 |  | 2021-09-09 00:00:00
118737 | Jun '21 | 2021-06-23 00:00:00 | 2021-09-09 00:00:00
118737 | Jul '21 |  | 2021-09-09 00:00:00
118737 | Aug '21 |  | 2021-09-09 00:00:00
118737 | Sep '21 | 2021-09-09 00:00:00 | 2021-09-09 00:00:00 |  |  | Need Differnce between RED & GREEN (IT should be 78)
118737 | Aug '20 |  | 2021-09-09 00:00:00
118737 | Sep '20 |  | 2021-09-09 00:00:00
118737 | Oct '20 |  | 2021-09-09 00:00:00
118737 | Nov '20 |  | 2021-09-09 00:00:00
118737 | Dec '20 |  | 2021-09-09 00:00:00
118737 | Jan '21 |  | 2021-09-09 00:00:00
118737 | Feb '21 |  | 2021-09-09 00:00:00
118737 | Mar '21 |  | 2021-09-09 00:00:00
118737 | Apr '21 |  | 2021-09-09 00:00:00
118737 | May '21 |  | 2021-09-09 00:00:00
118737 | Jun '21 |  | 2021-09-09 00:00:00
118737 | Jul '21 |  | 2021-09-09 00:00:00
118737 | Aug '21 |  | 2021-09-09 00:00:00
118737 | Sep '21 |  | 2021-09-09 00:00:00
119141 | Aug '20 | 2020-08-05 00:00:00 | 2021-06-23 00:00:00
119141 | Sep '20 | 2020-09-01 00:00:00 | 2021-06-23 00:00:00 |  |  | Need Differnce between RED & GREEN (it should be 27)
119141 | Oct '20 |  | 2021-06-23 00:00:00
119141 | Nov '20 |  | 2021-06-23 00:00:00
119141 | Dec '20 |  | 2021-06-23 00:00:00
119141 | Jan '21 |  | 2021-06-23 00:00:00
119141 | Feb '21 |  | 2021-06-23 00:00:00
119141 | Mar '21 |  | 2021-06-23 00:00:00
119141 | Apr '21 |  | 2021-06-23 00:00:00
119141 | May '21 |  | 2021-06-23 00:00:00
119141 | Jun '21 | 2021-06-23 00:00:00 | 2021-06-23 00:00:00
119141 | Jul '21 |  | 2021-06-23 00:00:00
119141 | Aug '21 |  | 2021-06-23 00:00:00
119141 | Sep '21 |  | 2021-06-23 00:00:00
119141 | Aug '20 |  | 2021-06-23 00:00:00
119141 | Sep '20 |  | 2021-06-23 00:00:00
119141 | Oct '20 |  | 2021-06-23 00:00:00
119141 | Nov '20 |  | 2021-06-23 00:00:00
119141 | Dec '20 |  | 2021-06-23 00:00:00
119141 | Jan '21 |  | 2021-06-23 00:00:00
119141 | Feb '21 |  | 2021-06-23 00:00:00
119141 | Mar '21 |  | 2021-06-23 00:00:00
119141 | Apr '21 |  | 2021-06-23 00:00:00
119141 | May '21 |  | 2021-06-23 00:00:00
119141 | Jun '21 |  | 2021-06-23 00:00:00
119141 | Jul '21 |  | 2021-06-23 00:00:00
119141 | Aug '21 |  | 2021-06-23 00:00:00
119141 | Sep '21 |  | 2021-06-23 00:00:00
119142 | Aug '20 |  | 2021-06-23 00:00:00
119142 | Sep '20 |  | 2021-06-23 00:00:00
119142 | Oct '20 |  | 2021-06-23 00:00:00
119142 | Nov '20 |  | 2021-06-23 00:00:00
119142 | Dec '20 |  | 2021-06-23 00:00:00
119142 | Jan '21 |  | 2021-06-23 00:00:00
119142 | Feb '21 |  | 2021-06-23 00:00:00
119142 | Mar '21 |  | 2021-06-23 00:00:00
119142 | Apr '21 |  | 2021-06-23 00:00:00
119142 | May '21 |  | 2021-06-23 00:00:00
119142 | Jun '21 | 2021-06-23 00:00:00 | 2021-06-23 00:00:00
119142 | Jul '21 |  | 2021-06-23 00:00:00
119142 | Aug '21 |  | 2021-06-23 00:00:00
119142 | Sep '21 |  | 2021-06-23 00:00:00
119142 | Aug '20 |  | 2021-06-23 00:00:00
119142 | Sep '20 |  | 2021-06-23 00:00:00
119142 | Oct '20 |  | 2021-06-23 00:00:00
119142 | Nov '20 |  | 2021-06-23 00:00:00
119142 | Dec '20 |  | 2021-06-23 00:00:00
119142 | Jan '21 |  | 2021-06-23 00:00:00
119142 | Feb '21 |  | 2021-06-23 00:00:00
119142 | Mar '21 |  | 2021-06-23 00:00:00
119142 | Apr '21 |  | 2021-06-23 00:00:00
119142 | May '21 |  | 2021-06-23 00:00:00
119142 | Jun '21 |  | 2021-06-23 00:00:00
119142 | Jul '21 |  | 2021-06-23 00:00:00
119142 | Aug '21 |  | 2021-06-23 00:00:00
119142 | Sep '21 |  | 2021-06-23 00:00:00
113479 | Aug '20 |  | 2021-06-30 00:00:00
113479 | Sep '20 |  | 2021-06-30 00:00:00
113479 | Oct '20 |  | 2021-06-30 00:00:00
113479 | Nov '20 |  | 2021-06-30 00:00:00
113479 | Dec '20 |  | 2021-06-30 00:00:00
113479 | Jan '21 |  | 2021-06-30 00:00:00
113479 | Feb '21 |  | 2021-06-30 00:00:00
113479 | Mar '21 |  | 2021-06-30 00:00:00
113479 | Apr '21 |  | 2021-06-30 00:00:00
113479 | May '21 |  | 2021-06-30 00:00:00
113479 | Jun '21 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00
113479 | Jul '21 |  | 2021-06-30 00:00:00
113479 | Aug '21 |  | 2021-06-30 00:00:00
113479 | Sep '21 |  | 2021-06-30 00:00:00