Spreadsheet: 770409d1646053465-calculate-how-many-days-people-have-from-start-date-until-end-date-from-month-to-month-enddate-aligw
Sheet: English (5)

February |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-02-28 00:00:00 | I want to get | AliGW
 | Anne | 2019-09-02 00:00:00 | 2021-01-31 00:00:00 |  |  | 0 |  |  | 1 | with both dates expired
 | Nina |  | 2021-09-30 00:00:00 |  |  | 30 |  |  | 2 | first zero and second with an non expired date
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0 |  |  | 3 | Both dates are existing but not expired or started
 | [NAME] | 2021-02-03 00:00:00 | 2021-10-31 00:00:00 |  |  | 28 |  |  | 4 | Starts in a month as the date has arrived but not expired
 | [NAME] |  |  |  |  | 0 |  |  | 5 | both zeros
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 |  |  | 0 |  |  | 6 | Season has not start and the second date is existing
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 30 |  |  | 7 | with both dates I get out 30
 | Heida | 2021-02-03 00:00:00 | 2021-02-18 00:00:00 |  |  |  |  |  | 8 | Within a month
 | Sandra | 2021-02-28 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  |  | 9 | Starts in a month, as the date has come but not expired
 | Eva | 2022-11-03 00:00:00 |  |  |  | 0 |  |  | 10 | Season not started and missing second date
 | [NAME] | 2020-12-31 00:00:00 | 2021-02-15 00:00:00 |  |  | 15 |  |  | 11 | Ends in the month
Oktobere |  |  |  |  |  | 0
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be
January |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-01-31 00:00:00 | I want to get | AliGW
 | [NAME] | 2019-09-02 00:00:00 | 2020-12-31 00:00:00 |  |  | 0 |  |  | 1 | with both dates expired
 | Siggi |  | 2021-09-30 00:00:00 |  |  | 30 |  |  | 2 | first zero and second with an non expired date
 | Gunnar | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0 |  |  | 3 | Both dates are existing but not expired or started
 | [NAME] | 2021-01-03 00:00:00 | 2021-10-31 00:00:00 |  |  |  |  |  | 4 | Starts in a month as the date has arrived but not expired
 | [NAME] |  |  |  |  | 0 |  |  | 5 | both zeros
 | Micael | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 |  |  | 0 |  |  | 6 | Season has not start and the second date is existing
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 30 |  |  | 7 | with both dates I get out 30
 | [NAME] | 2021-01-05 00:00:00 | 2021-01-25 00:00:00 |  |  |  |  |  | 8 | Within a month
 | Jonny | 2021-01-20 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  |  | 9 | Starts in a month, as the date has come but not expired
 | Gudman | 2022-11-03 00:00:00 |  |  |  | 0 |  |  | 10 | Season not started and missing second date
 | Olaf | 2020-11-30 00:00:00 | 2021-01-10 00:00:00 |  |  | 10 |  |  | 11 | Ends in the month
 | Anne | 2021-01-01 00:00:00
 | Nina |  | 2021-09-30 00:00:00
January |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2022-01-31 00:00:00 | I want to get | AliGW
 | NN1 | 2019-09-02 00:00:00 | 2021-03-19 00:00:00 |  |  | 0
 | NN2 | 2020-12-16 00:00:00 | 2022-01-10 00:00:00 |  |  | 10
 | NN3 | 2022-01-05 00:00:00
 | NN4 | 2022-01-15 00:00:00
 | NN5 |  |  |  |  | 0
 | NN6 | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 |  |  | 0
 | NN7 | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 0
 | NN8 | 2021-01-05 00:00:00 | 2021-01-25 00:00:00 |  |  | 0
 | NN9 | 2021-01-20 00:00:00 | 2021-12-31 00:00:00 |  |  | 0
 | NN10 | 2022-11-03 00:00:00 |  |  |  | 0
 | NN11 | 2020-11-30 00:00:00 | 2021-01-10 00:00:00 |  |  | 0