Spreadsheet: 676365d1588775172-calculating-days-in-individual-months-between-arrival-date-and-departure-date-table-days-in-each-month-eg
Sheet: Sheet1

Arv_Date | Dep_Dt | Days_in_Month_Arv | Days_in_Month_Dep | 12/5/2019 | 1/31/2014 | 2/28/2014 | 3/31/2014 | 4/30/2014 | 5/31/2014 | 6/30/2014 | 7/31/2014 | 8/31/2014 | 9/30/2014 | 10/31/2014 | 11/30/2014 | 12/31/2014 |  | Arrive - Dep | Sum of months | Match?
2014-01-25 00:00:00 | 2014-02-01 00:00:00
2014-02-01 00:00:00 | 2014-02-08 00:00:00
2014-02-08 00:00:00 | 2014-02-24 00:00:00
2014-02-24 00:00:00 | 2014-03-01 00:00:00
2014-03-01 00:00:00 | 2014-03-15 00:00:00
2014-03-15 00:00:00 | 2014-03-22 00:00:00
2014-03-22 00:00:00 | 2014-03-29 00:00:00
2014-03-29 00:00:00 | 2014-04-05 00:00:00
2014-04-05 00:00:00 | 2014-04-12 00:00:00
2014-04-12 00:00:00 | 2014-04-19 00:00:00
2014-04-19 00:00:00 | 2014-04-26 00:00:00
2014-04-26 00:00:00 | 2014-05-03 00:00:00
2014-05-04 00:00:00 | 2014-05-10 00:00:00
2014-05-11 00:00:00 | 2014-05-15 00:00:00
2014-05-17 00:00:00 | 2014-05-24 00:00:00
2014-05-24 00:00:00 | 2014-05-30 00:00:00
2014-05-30 00:00:00 | 2014-06-04 00:00:00
2014-06-07 00:00:00 | 2014-06-14 00:00:00
2014-06-14 00:00:00 | 2014-06-22 00:00:00
2014-06-22 00:00:00 | 2014-06-29 00:00:00
2014-07-01 00:00:00 | 2014-07-05 00:00:00
2014-07-05 00:00:00 | 2014-07-12 00:00:00
2014-07-12 00:00:00 | 2014-07-19 00:00:00
2014-07-19 00:00:00 | 2014-07-26 00:00:00
2014-07-26 00:00:00 | 2014-08-02 00:00:00
2014-08-02 00:00:00 | 2014-08-09 00:00:00
2014-08-09 00:00:00 | 2014-08-13 00:00:00
2014-08-25 00:00:00 | 2014-08-29 00:00:00
2014-08-29 00:00:00 | 2014-09-02 00:00:00
2014-09-06 00:00:00 | 2014-09-10 00:00:00
2014-09-11 00:00:00 | 2014-09-15 00:00:00
2014-09-18 00:00:00 | 2014-09-21 00:00:00
2014-10-04 00:00:00 | 2014-10-11 00:00:00
2014-10-12 00:00:00 | 2014-10-16 00:00:00
2014-10-20 00:00:00 | 2014-10-27 00:00:00
2014-10-27 00:00:00 | 2014-10-31 00:00:00
2014-10-31 00:00:00 | 2014-11-03 00:00:00
2014-11-22 00:00:00 | 2014-11-29 00:00:00
2014-12-06 00:00:00 | 2014-12-13 00:00:00
2014-12-20 00:00:00 | 2014-12-27 00:00:00
2014-12-29 00:00:00 | 2015-01-02 00:00:00
2015-01-02 00:00:00 | 2015-01-03 00:00:00
2015-01-03 00:00:00 | 2015-01-10 00:00:00
2015-01-10 00:00:00 | 2015-01-24 00:00:00
2015-01-24 00:00:00 | 2015-02-28 00:00:00
2015-02-28 00:00:00 | 2015-03-14 00:00:00
2015-03-14 00:00:00 | 2015-03-28 00:00:00
2015-03-28 00:00:00 | 2015-04-02 00:00:00
2015-04-02 00:00:00 | 2015-04-04 00:00:00
2015-04-04 00:00:00 | 2015-04-11 00:00:00
2015-04-15 00:00:00 | 2015-04-20 00:00:00
2015-04-22 00:00:00 | 2015-04-25 00:00:00
2015-04-25 00:00:00 | 2015-05-02 00:00:00
2015-05-09 00:00:00 | 2015-05-16 00:00:00
2015-05-16 00:00:00 | 2015-05-23 00:00:00
2015-05-23 00:00:00 | 2015-05-30 00:00:00
2015-05-30 00:00:00 | 2015-06-06 00:00:00
2015-06-07 00:00:00 | 2015-06-11 00:00:00
2015-06-12 00:00:00 | 2015-06-16 00:00:00
2015-06-17 00:00:00 | 2015-06-20 00:00:00
2015-06-20 00:00:00 | 2015-06-27 00:00:00
2015-06-27 00:00:00 | 2015-07-03 00:00:00
2015-07-04 00:00:00 | 2015-07-09 00:00:00
2015-07-11 00:00:00 | 2015-07-18 00:00:00
2015-07-18 00:00:00 | 2015-07-25 00:00:00
2015-07-25 00:00:00 | 2015-08-01 00:00:00
2015-08-01 00:00:00 | 2015-08-08 00:00:00
2015-08-08 00:00:00 | 2015-08-09 00:00:00
2015-08-09 00:00:00 | 2015-08-15 00:00:00
2015-08-15 00:00:00 | 2015-08-19 00:00:00
2015-08-19 00:00:00 | 2015-08-23 00:00:00
2015-08-25 00:00:00 | 2015-09-01 00:00:00
2015-09-02 00:00:00 | 2015-09-09 00:00:00
2015-09-11 00:00:00 | 2015-09-15 00:00:00
2015-09-24 00:00:00 | 2015-09-27 00:00:00
2015-10-02 00:00:00 | 2015-10-04 00:00:00
2015-10-05 00:00:00 | 2015-10-19 00:00:00
2015-10-19 00:00:00 | 2015-10-22 00:00:00
2015-10-26 00:00:00 | 2015-11-09 00:00:00
2015-11-10 00:00:00 | 2015-11-14 00:00:00
2015-11-15 00:00:00 | 2015-11-21 00:00:00
2015-11-23 00:00:00 | 2015-11-29 00:00:00
2015-12-10 00:00:00 | 2015-12-14 00:00:00
2015-12-19 00:00:00 | 2015-12-26 00:00:00
2015-12-26 00:00:00 | 2016-01-02 00:00:00
2016-01-02 00:00:00 | 2016-01-09 00:00:00
2016-01-16 00:00:00 | 2016-02-27 00:00:00
2016-02-27 00:00:00 | 2016-03-12 00:00:00
2016-03-12 00:00:00 | 2016-03-19 00:00:00
2016-03-19 00:00:00 | 2016-03-26 00:00:00
2016-03-26 00:00:00 | 2016-04-02 00:00:00
2016-04-02 00:00:00 | 2016-04-09 00:00:00
2016-04-09 00:00:00 | 2016-04-23 00:00:00
2016-04-23 00:00:00 | 2016-05-01 00:00:00
2016-05-04 00:00:00 | 2016-05-08 00:00:00
2016-05-08 00:00:00 | 2016-05-14 00:00:00
2016-05-16 00:00:00 | 2016-05-20 00:00:00
2016-05-25 00:00:00 | 2016-05-29 00:00:00
2016-05-29 00:00:00 | 2016-06-04 00:00:00
2016-06-04 00:00:00 | 2016-06-11 00:00:00
2016-06-11 00:00:00 | 2016-06-18 00:00:00
2016-06-19 00:00:00 | 2016-06-25 00:00:00
2016-06-25 00:00:00 | 2016-07-02 00:00:00
2016-07-02 00:00:00 | 2016-07-10 00:00:00
2016-07-10 00:00:00 | 2016-07-15 00:00:00
2016-07-16 00:00:00 | 2016-07-23 00:00:00
2016-07-23 00:00:00 | 2016-07-30 00:00:00
2016-07-31 00:00:00 | 2016-08-03 00:00:00
2016-08-04 00:00:00 | 2016-08-12 00:00:00
2016-08-15 00:00:00 | 2016-08-26 00:00:00
2016-09-05 00:00:00 | 2016-09-09 00:00:00
2016-09-13 00:00:00 | 2016-09-17 00:00:00
2016-10-01 00:00:00 | 2016-10-08 00:00:00
2016-10-12 00:00:00 | 2016-10-17 00:00:00
2016-10-22 00:00:00 | 2016-10-29 00:00:00
2016-11-12 00:00:00 | 2016-11-18 00:00:00
2016-11-18 00:00:00 | 2016-11-21 00:00:00
2016-11-27 00:00:00 | 2016-12-21 00:00:00
2016-12-24 00:00:00 | 2016-12-30 00:00:00
2016-12-31 00:00:00 | 2017-01-07 00:00:00
2017-01-29 00:00:00 | 2017-02-02 00:00:00
2017-02-04 00:00:00 | 2017-02-11 00:00:00
2017-02-11 00:00:00 | 2017-02-18 00:00:00
2017-02-18 00:00:00 | 2017-02-25 00:00:00
2017-02-25 00:00:00 | 2017-03-18 00:00:00
2017-03-18 00:00:00 | 2017-03-25 00:00:00
2017-03-25 00:00:00 | 2017-04-01 00:00:00
2017-04-01 00:00:00 | 2017-04-08 00:00:00
2017-04-08 00:00:00 | 2017-04-15 00:00:00
2017-04-28 00:00:00 | 2017-05-08 00:00:00
2017-05-09 00:00:00 | 2017-05-16 00:00:00
2017-05-20 00:00:00 | 2017-05-27 00:00:00
2017-06-03 00:00:00 | 2017-06-10 00:00:00
2017-06-10 00:00:00 | 2017-06-17 00:00:00
2017-06-17 00:00:00 | 2017-06-24 00:00:00
2017-07-01 00:00:00 | 2017-07-08 00:00:00
2017-07-11 00:00:00 | 2017-07-17 00:00:00
2017-07-19 00:00:00 | 2017-07-28 00:00:00
2017-07-28 00:00:00 | 2017-08-04 00:00:00
2017-08-04 00:00:00 | 2017-08-11 00:00:00
2017-08-13 00:00:00 | 2017-08-20 00:00:00
2017-08-21 00:00:00 | 2017-08-31 00:00:00
2017-09-05 00:00:00 | 2017-09-11 00:00:00
2017-09-22 00:00:00 | 2017-09-27 00:00:00
2017-10-04 00:00:00 | 2017-10-12 00:00:00
2017-10-16 00:00:00 | 2017-10-21 00:00:00
2017-10-23 00:00:00 | 2017-10-30 00:00:00
2017-11-01 00:00:00 | 2017-11-11 00:00:00
2017-11-18 00:00:00 | 2017-11-25 00:00:00
2017-12-02 00:00:00 | 2017-12-06 00:00:00
2017-12-06 00:00:00 | 2017-12-13 00:00:00
2017-12-19 00:00:00 | 2017-12-23 00:00:00
2017-12-28 00:00:00 | 2018-01-05 00:00:00
2018-01-20 00:00:00 | 2018-02-03 00:00:00
2018-02-03 00:00:00 | 2018-02-09 00:00:00
2018-02-10 00:00:00 | 2018-02-17 00:00:00
2018-02-17 00:00:00 | 2018-02-24 00:00:00
2018-02-24 00:00:00 | 2018-03-17 00:00:00
2018-03-19 00:00:00 | 2018-03-24 00:00:00
2018-03-25 00:00:00 | 2018-03-31 00:00:00
2018-03-31 00:00:00 | 2018-04-06 00:00:00
2018-04-07 00:00:00 | 2018-04-14 00:00:00
2018-04-17 00:00:00 | 2018-04-26 00:00:00
2018-05-03 00:00:00 | 2018-05-08 00:00:00
2018-05-09 00:00:00 | 2018-05-16 00:00:00
2018-05-25 00:00:00 | 2018-06-02 00:00:00
2018-06-09 00:00:00 | 2018-06-16 00:00:00
2018-06-16 00:00:00 | 2018-06-23 00:00:00
2018-06-24 00:00:00 | 2018-06-30 00:00:00
2018-06-30 00:00:00 | 2018-07-07 00:00:00
2018-07-08 00:00:00 | 2018-07-13 00:00:00
2018-07-14 00:00:00 | 2018-07-21 00:00:00
2018-07-21 00:00:00 | 2018-07-27 00:00:00
2018-07-28 00:00:00 | 2018-08-03 00:00:00
2018-08-04 00:00:00 | 2018-08-11 00:00:00
2018-08-11 00:00:00 | 2018-08-18 00:00:00
2018-08-18 00:00:00 | 2018-09-02 00:00:00
2018-09-02 00:00:00 | 2018-09-09 00:00:00
2018-09-15 00:00:00 | 2018-09-18 00:00:00
2018-09-19 00:00:00 | 2018-09-22 00:00:00
2018-09-23 00:00:00 | 2018-09-27 00:00:00
2018-09-27 00:00:00 | 2018-09-30 00:00:00
2018-10-04 00:00:00 | 2018-10-10 00:00:00
2018-10-15 00:00:00 | 2018-10-20 00:00:00
2018-10-20 00:00:00 | 2018-10-27 00:00:00
2018-10-28 00:00:00 | 2018-11-15 00:00:00
2018-11-20 00:00:00 | 2018-11-26 00:00:00
2018-11-26 00:00:00 | 2018-12-22 00:00:00
2018-12-22 00:00:00 | 2018-12-28 00:00:00
2018-12-29 00:00:00 | 2019-01-05 00:00:00
2019-01-05 00:00:00 | 2019-01-12 00:00:00
2019-01-12 00:00:00 | 2019-01-26 00:00:00
2019-01-26 00:00:00 | 2019-02-02 00:00:00
2019-02-02 00:00:00 | 2019-03-02 00:00:00
2019-03-02 00:00:00 | 2019-03-30 00:00:00
2019-03-30 00:00:00 | 2019-04-06 00:00:00
2019-04-27 00:00:00 | 2019-05-03 00:00:00
2019-05-03 00:00:00 | 2019-05-05 00:00:00
2019-05-09 00:00:00 | 2019-05-12 00:00:00
2019-05-17 00:00:00 | 2019-05-19 00:00:00
2019-05-19 00:00:00 | 2019-05-25 00:00:00
2019-06-01 00:00:00 | 2019-06-08 00:00:00
2019-06-08 00:00:00 | 2019-06-15 00:00:00
2019-06-15 00:00:00 | 2019-06-22 00:00:00
2019-06-22 00:00:00 | 2019-06-29 00:00:00
2019-06-29 00:00:00 | 2019-07-13 00:00:00
2019-07-13 00:00:00 | 2019-07-20 00:00:00
2019-07-20 00:00:00 | 2019-07-27 00:00:00
2019-07-27 00:00:00 | 2019-08-03 00:00:00
2019-08-03 00:00:00 | 2019-08-10 00:00:00
2019-08-16 00:00:00 | 2019-08-24 00:00:00
2019-08-24 00:00:00 | 2019-08-31 00:00:00
2019-09-06 00:00:00 | 2019-09-09 00:00:00
2019-09-12 00:00:00 | 2019-09-15 00:00:00
2019-09-21 00:00:00 | 2019-09-28 00:00:00
2019-09-28 00:00:00 | 2019-10-05 00:00:00
2019-10-12 00:00:00 | 2019-10-19 00:00:00
2019-11-06 00:00:00 | 2019-11-16 00:00:00
2019-12-01 00:00:00 | 2019-12-08 00:00:00
2019-12-17 00:00:00 | 2020-01-04 00:00:00
2020-01-04 00:00:00 | 2020-01-25 00:00:00
2020-02-08 00:00:00 | 2020-02-29 00:00:00
2020-02-29 00:00:00 | 2020-03-28 00:00:00