Spreadsheet: 708590d1607941663-count-of-days-per-month-for-a-contract-period-test
Sheet: Sheet1

Employee ID | Employee Name | Employee Substatus Name | Contract No. | Start Date | End Date | 2020-01-01 00:00:00
E001 | Name 1 | ESN | C001 | 2019-05-15 00:00:00 | 2020-02-28 00:00:00
E002 | Name 2 | ESN | C002 | 2019-04-05 00:00:00 | 2020-05-07 00:00:00
E003 | Name 3 | ESN | C003 | 2019-01-14 00:00:00 | 2019-12-07 00:00:00
E004 | Name 4 | ESN | C004 | 2019-06-01 00:00:00 | 2020-06-08 00:00:00
E005 | Name 5 | ESN | C005 | 2019-03-13 00:00:00 | 2019-10-19 00:00:00
E006 | Name 6 | ESN | C006 | 2020-03-03 00:00:00 | 2020-08-17 00:00:00
E007 | Name 7 | ESN | C007 | 2019-02-03 00:00:00 | 2019-07-15 00:00:00
E008 | Name 8 | ESN | C008 | 2019-09-27 00:00:00 | 2020-05-12 00:00:00
E009 | Name 9 | ESN | C009 | 2019-04-12 00:00:00 | 2019-08-18 00:00:00
E010 | Name 10 | ESN | C010 | 2019-12-09 00:00:00 | 2020-12-26 00:00:00
E011 | Name 11 | ESN | C011 | 2019-10-08 00:00:00 | 2020-05-16 00:00:00
E012 | Name 12 | ESN | C012 | 2019-05-07 00:00:00 | 2019-10-16 00:00:00
E013 | Name 13 | ESN | C013 | 2019-03-25 00:00:00 | 2020-04-26 00:00:00
E014 | Name 14 | ESN | C014 | 2019-06-16 00:00:00 | 2019-10-26 00:00:00
E015 | Name 15 | ESN | C015 | 2019-04-29 00:00:00 | 2020-05-29 00:00:00
E016 | Name 16 | ESN | C016 | 2019-06-30 00:00:00 | 2020-06-19 00:00:00
E017 | Name 17 | ESN | C017 | 2019-05-16 00:00:00 | 2020-04-21 00:00:00
E018 | Name 18 | ESN | C018 | 2019-08-19 00:00:00 | 2020-08-02 00:00:00
E019 | Name 19 | ESN | C019 | 2019-06-06 00:00:00 | 2020-01-26 00:00:00
E020 | Name 20 | ESN | C020 | 2019-07-21 00:00:00 | 2020-01-02 00:00:00
E021 | Name 21 | ESN | C021 | 2019-01-21 00:00:00 | 2020-01-17 00:00:00
E022 | Name 22 | ESN | C022 | 2019-04-29 00:00:00 | 2020-05-27 00:00:00
E023 | Name 23 | ESN | C023 | 2019-05-21 00:00:00 | 2020-06-04 00:00:00
E024 | Name 24 | ESN | C024 | 2019-07-07 00:00:00 | 2019-12-27 00:00:00
E025 | Name 25 | ESN | C025 | 2019-07-16 00:00:00 | 2020-03-17 00:00:00
E026 | Name 26 | ESN | C026 | 2019-02-24 00:00:00 | 2020-01-05 00:00:00
E027 | Name 27 | ESN | C027 | 2019-12-24 00:00:00 | 2020-05-09 00:00:00
E028 | Name 28 | ESN | C028 | 2019-07-31 00:00:00 | 2020-02-15 00:00:00
E029 | Name 29 | ESN | C029 | 2019-04-03 00:00:00 | 2019-09-28 00:00:00
E030 | Name 30 | ESN | C030 | 2020-02-11 00:00:00 | 2021-02-13 00:00:00
E031 | Name 31 | ESN | C031 | 2020-01-02 00:00:00 | 2021-02-01 00:00:00
E032 | Name 32 | ESN | C032 | 2019-04-15 00:00:00 | 2020-03-12 00:00:00
E033 | Name 33 | ESN | C033 | 2019-05-30 00:00:00 | 2020-03-15 00:00:00
E034 | Name 34 | ESN | C034 | 2019-08-09 00:00:00 | 2020-08-18 00:00:00
E035 | Name 35 | ESN | C035 | 2020-02-05 00:00:00 | 2021-02-08 00:00:00
E036 | Name 36 | ESN | C036 | 2019-08-06 00:00:00 | 2020-05-03 00:00:00
E037 | Name 37 | ESN | C037 | 2020-02-12 00:00:00 | 2020-09-25 00:00:00
E038 | Name 38 | ESN | C038 | 2019-07-04 00:00:00 | 2020-03-29 00:00:00
E039 | Name 39 | ESN | C039 | 2019-07-15 00:00:00 | 2019-11-28 00:00:00
E040 | Name 40 | ESN | C040 | 2019-01-29 00:00:00 | 2019-07-05 00:00:00
E041 | Name 41 | ESN | C041 | 2019-06-03 00:00:00 | 2019-10-19 00:00:00
E042 | Name 42 | ESN | C042 | 2020-03-04 00:00:00 | 2020-10-21 00:00:00
E043 | Name 43 | ESN | C043 | 2019-09-06 00:00:00 | 2020-07-13 00:00:00
E044 | Name 44 | ESN | C044 | 2019-09-05 00:00:00 | 2020-06-05 00:00:00
E045 | Name 45 | ESN | C045 | 2019-09-23 00:00:00 | 2020-02-21 00:00:00
E046 | Name 46 | ESN | C046 | 2019-10-17 00:00:00 | 2020-08-29 00:00:00
E047 | Name 47 | ESN | C047 | 2019-04-01 00:00:00 | 2020-04-18 00:00:00
E048 | Name 48 | ESN | C048 | 2020-01-03 00:00:00 | 2021-01-21 00:00:00
E049 | Name 49 | ESN | C049 | 2019-12-01 00:00:00 | 2020-12-04 00:00:00
E050 | Name 50 | ESN | C050 | 2019-08-15 00:00:00 | 2019-12-30 00:00:00
E051 | Name 51 | ESN | C051 | 2019-09-30 00:00:00 | 2020-10-04 00:00:00
E052 | Name 52 | ESN | C052 | 2019-10-30 00:00:00 | 2020-09-08 00:00:00
E053 | Name 53 | ESN | C053 | 2019-07-30 00:00:00 | 2019-12-21 00:00:00
E054 | Name 54 | ESN | C054 | 2019-01-21 00:00:00 | 2019-10-02 00:00:00
E055 | Name 55 | ESN | C055 | 2019-07-07 00:00:00 | 2020-04-06 00:00:00
E056 | Name 56 | ESN | C056 | 2019-06-23 00:00:00 | 2020-04-28 00:00:00
E057 | Name 57 | ESN | C057 | 2019-03-12 00:00:00 | 2020-01-05 00:00:00
E058 | Name 58 | ESN | C058 | 2020-02-10 00:00:00 | 2020-06-28 00:00:00
E059 | Name 59 | ESN | C059 | 2019-06-29 00:00:00 | 2020-05-14 00:00:00
E060 | Name 60 | ESN | C060 | 2019-01-05 00:00:00 | 2019-11-05 00:00:00
E061 | Name 61 | ESN | C061 | 2019-05-10 00:00:00 | 2019-10-25 00:00:00
E062 | Name 62 | ESN | C062 | 2019-05-18 00:00:00 | 2019-09-22 00:00:00
E063 | Name 63 | ESN | C063 | 2020-01-30 00:00:00 | 2020-06-09 00:00:00
E064 | Name 64 | ESN | C064 | 2019-10-13 00:00:00 | 2020-10-21 00:00:00
E065 | Name 65 | ESN | C065 | 2019-05-24 00:00:00 | 2020-05-25 00:00:00
E066 | Name 66 | ESN | C066 | 2019-12-10 00:00:00 | 2020-08-30 00:00:00
E067 | Name 67 | ESN | C067 | 2019-03-14 00:00:00 | 2020-02-22 00:00:00
E068 | Name 68 | ESN | C068 | 2019-03-27 00:00:00 | 2019-09-27 00:00:00
E069 | Name 69 | ESN | C069 | 2019-04-30 00:00:00 | 2019-11-14 00:00:00
E070 | Name 70 | ESN | C070 | 2019-02-04 00:00:00 | 2019-07-24 00:00:00
E071 | Name 71 | ESN | C071 | 2019-02-27 00:00:00 | 2019-07-14 00:00:00
E072 | Name 72 | ESN | C072 | 2019-12-21 00:00:00 | 2021-01-11 00:00:00
E073 | Name 73 | ESN | C073 | 2019-09-29 00:00:00 | 2020-08-18 00:00:00
E074 | Name 74 | ESN | C074 | 2020-02-25 00:00:00 | 2021-01-11 00:00:00
E075 | Name 75 | ESN | C075 | 2020-01-27 00:00:00 | 2021-02-24 00:00:00
E076 | Name 76 | ESN | C076 | 2020-02-20 00:00:00 | 2020-08-10 00:00:00
E077 | Name 77 | ESN | C077 | 2019-06-09 00:00:00 | 2020-04-19 00:00:00
E078 | Name 78 | ESN | C078 | 2019-07-14 00:00:00 | 2019-11-18 00:00:00
E079 | Name 79 | ESN | C079 | 2020-02-25 00:00:00 | 2020-08-14 00:00:00
E080 | Name 80 | ESN | C080 | 2019-10-27 00:00:00 | 2020-09-27 00:00:00
E081 | Name 81 | ESN | C081 | 2019-03-11 00:00:00 | 2020-02-13 00:00:00
E082 | Name 82 | ESN | C082 | 2019-11-28 00:00:00 | 2020-07-17 00:00:00
E083 | Name 83 | ESN | C083 | 2019-11-17 00:00:00 | 2020-08-25 00:00:00
E084 | Name 84 | ESN | C084 | 2019-11-07 00:00:00 | 2020-12-11 00:00:00
E085 | Name 85 | ESN | C085 | 2019-06-18 00:00:00 | 2020-05-05 00:00:00
E086 | Name 86 | ESN | C086 | 2019-05-15 00:00:00 | 2019-09-27 00:00:00
E087 | Name 87 | ESN | C087 | 2019-09-16 00:00:00 | 2020-05-04 00:00:00
E088 | Name 88 | ESN | C088 | 2019-11-15 00:00:00 | 2020-05-29 00:00:00
E089 | Name 89 | ESN | C089 | 2020-03-29 00:00:00 | 2021-03-11 00:00:00
E090 | Name 90 | ESN | C090 | 2019-04-16 00:00:00 | 2020-05-09 00:00:00
E091 | Name 91 | ESN | C091 | 2019-06-27 00:00:00 | 2020-04-21 00:00:00
E092 | Name 92 | ESN | C092 | 2019-06-19 00:00:00 | 2020-04-03 00:00:00
E093 | Name 93 | ESN | C093 | 2019-01-02 00:00:00 | 2019-06-12 00:00:00
E094 | Name 94 | ESN | C094 | 2019-05-02 00:00:00 | 2019-12-07 00:00:00
E095 | Name 95 | ESN | C095 | 2019-03-11 00:00:00 | 2020-04-01 00:00:00
E096 | Name 96 | ESN | C096 | 2019-11-21 00:00:00 | 2020-04-13 00:00:00
E097 | Name 97 | ESN | C097 | 2019-10-07 00:00:00 | 2020-06-29 00:00:00
E098 | Name 98 | ESN | C098 | 2019-11-05 00:00:00 | 2020-09-21 00:00:00
E099 | Name 99 | ESN | C099 | 2019-11-23 00:00:00 | 2020-10-02 00:00:00
E100 | Name 100 | ESN | C100 | 2019-02-04 00:00:00 | 2020-02-22 00:00:00
E101 | Name 101 | ESN | C101 | 2019-05-10 00:00:00 | 2020-04-05 00:00:00
E102 | Name 102 | ESN | C102 | 2019-05-10 00:00:00 | 2019-09-16 00:00:00
E103 | Name 103 | ESN | C103 | 2019-02-12 00:00:00 | 2019-06-29 00:00:00
E104 | Name 104 | ESN | C104 | 2019-04-28 00:00:00 | 2019-11-24 00:00:00
E105 | Name 105 | ESN | C105 | 2019-06-11 00:00:00 | 2020-07-09 00:00:00
E106 | Name 106 | ESN | C106 | 2020-03-30 00:00:00 | 2020-11-14 00:00:00
E107 | Name 107 | ESN | C107 | 2019-07-10 00:00:00 | 2020-01-05 00:00:00
E108 | Name 108 | ESN | C108 | 2019-11-28 00:00:00 | 2020-09-19 00:00:00
E109 | Name 109 | ESN | C109 | 2019-02-26 00:00:00 | 2019-08-02 00:00:00
E110 | Name 110 | ESN | C110 | 2020-01-03 00:00:00 | 2020-10-06 00:00:00
E111 | Name 111 | ESN | C111 | 2020-02-27 00:00:00 | 2020-07-25 00:00:00
E112 | Name 112 | ESN | C112 | 2019-11-27 00:00:00 | 2020-04-27 00:00:00
E113 | Name 113 | ESN | C113 | 2019-10-03 00:00:00 | 2020-09-23 00:00:00
E114 | Name 114 | ESN | C114 | 2020-03-17 00:00:00 | 2020-10-11 00:00:00
E115 | Name 115 | ESN | C115 | 2019-11-10 00:00:00 | 2020-07-03 00:00:00
E116 | Name 116 | ESN | C116 | 2019-10-30 00:00:00 | 2020-04-27 00:00:00
E117 | Name 117 | ESN | C117 | 2019-09-15 00:00:00 | 2020-06-17 00:00:00
E118 | Name 118 | ESN | C118 | 2020-01-03 00:00:00 | 2020-12-05 00:00:00
E119 | Name 119 | ESN | C119 | 2019-11-29 00:00:00 | 2020-11-26 00:00:00
E120 | Name 120 | ESN | C120 | 2019-12-12 00:00:00 | 2020-08-08 00:00:00
E121 | Name 121 | ESN | C121 | 2020-01-01 00:00:00 | 2020-10-02 00:00:00
E122 | Name 122 | ESN | C122 | 2019-02-09 00:00:00 | 2019-07-01 00:00:00
E123 | Name 123 | ESN | C123 | 2019-10-02 00:00:00 | 2020-06-28 00:00:00
E124 | Name 124 | ESN | C124 | 2020-03-29 00:00:00 | 2021-02-23 00:00:00
E125 | Name 125 | ESN | C125 | 2019-08-05 00:00:00 | 2020-01-23 00:00:00
E126 | Name 126 | ESN | C126 | 2019-11-11 00:00:00 | 2020-06-08 00:00:00
E127 | Name 127 | ESN | C127 | 2020-03-27 00:00:00 | 2021-01-25 00:00:00
E128 | Name 128 | ESN | C128 | 2019-11-22 00:00:00 | 2020-09-15 00:00:00
E129 | Name 129 | ESN | C129 | 2019-04-27 00:00:00 | 2019-10-23 00:00:00
E130 | Name 130 | ESN | C130 | 2020-03-04 00:00:00 | 2020-09-17 00:00:00
E131 | Name 131 | ESN | C131 | 2019-09-04 00:00:00 | 2020-06-22 00:00:00