Spreadsheet: 684899d1593608313-total-cells-if-within-a-certain-date-date-calculation-total
Sheet: Sheet1

Employee Id | Other Events Start Date | Other Events End Date | Total Duration (Days)
PW4 | 2020-05-15 00:00:00 | 2020-05-22 00:00:00 | 8
PW4 | 2020-06-01 00:00:00 | 2020-06-01 00:00:00 | 1
PW4 | 2020-07-03 00:00:00 | 2020-07-06 00:00:00 | 4
PW4 | 2020-07-09 00:00:00 | 2020-07-13 00:00:00 | 5
PW4 | 2020-07-17 00:00:00 | 2020-07-20 00:00:00 | 4
PW4 | 2020-07-24 00:00:00 | 2020-07-27 00:00:00 | 4
PW686 | 2020-04-03 00:00:00 | 2020-06-07 00:00:00 | 62
PW872 | 2020-04-03 00:00:00 | 2020-05-10 00:00:00 | 35
PW872 | 2020-05-12 00:00:00 | 2020-06-07 00:00:00 | 26
PW1054 | 2020-04-20 00:00:00 | 2020-06-30 00:00:00 | 70
PW1054 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 0.5
PW1054 | 2020-07-02 00:00:00 | 2020-07-02 00:00:00 | 0.5
PW1054 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 0.5
PW1054 | 2020-07-06 00:00:00 | 2020-07-06 00:00:00 | 0.5
PW1054 | 2020-07-07 00:00:00 | 2020-07-07 00:00:00 | 0.5
PW1054 | 2020-07-08 00:00:00 | 2020-07-08 00:00:00 | 0.5
PW1054 | 2020-07-09 00:00:00 | 2020-07-09 00:00:00 | 0.5
PW1054 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 0.5
PW1054 | 2020-07-13 00:00:00 | 2020-07-13 00:00:00 | 0.5
PW1054 | 2020-07-14 00:00:00 | 2020-07-14 00:00:00 | 0.5
PW1054 | 2020-07-15 00:00:00 | 2020-07-15 00:00:00 | 0.5
PW1054 | 2020-07-16 00:00:00 | 2020-07-16 00:00:00 | 0.5
PW1054 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 0.5
PW1054 | 2020-07-20 00:00:00 | 2020-07-20 00:00:00 | 0.5
PW1054 | 2020-07-21 00:00:00 | 2020-07-21 00:00:00 | 0.5
PW1054 | 2020-07-22 00:00:00 | 2020-07-22 00:00:00 | 0.5
PW1054 | 2020-07-23 00:00:00 | 2020-07-23 00:00:00 | 0.5
PW1054 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 0.5
PW1054 | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | 0.5
PW1054 | 2020-07-28 00:00:00 | 2020-07-28 00:00:00 | 0.5
PW1054 | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 0.5
PW1054 | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 | 0.5
PW1054 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 0.5
PW790 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW1042 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
PW677 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
[NAME] | 2020-04-03 00:00:00 | 2020-06-16 00:00:00 | 75
PW867 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
PW876 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
PW148 | 2020-04-06 00:00:00 | 2020-04-14 00:00:00 | 9
PW148 | 2020-04-16 00:00:00 | 2020-05-31 00:00:00 | 46
PW898 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
PW899 | 2020-04-13 00:00:00 | 2020-07-31 00:00:00 | 110
PW902 | 2020-04-09 00:00:00 | 2020-07-31 00:00:00 | 110
PW905 | 2020-04-06 00:00:00 | 2020-06-14 00:00:00 | 70
PW937 | 2020-04-20 00:00:00 | 2020-06-30 00:00:00 | 70
PW930 | 2020-04-08 00:00:00 | 2020-04-13 00:00:00 | 6
PW930 | 2020-04-15 00:00:00 | 2020-04-16 00:00:00 | 2
PW930 | 2020-04-18 00:00:00 | 2020-07-01 00:00:00 | 75
PW89 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
PW963 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 120
PW800 | 2020-04-06 00:00:00 | 2020-06-30 00:00:00 | 86
PW800 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW800 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW800 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW800 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW800 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW800 | 2020-07-02 00:00:00 | 2020-07-02 00:00:00 | 0.5
PW800 | 2020-07-09 00:00:00 | 2020-07-09 00:00:00 | 0.5
PW800 | 2020-07-16 00:00:00 | 2020-07-16 00:00:00 | 0.5
PW800 | 2020-07-23 00:00:00 | 2020-07-23 00:00:00 | 0.5
PW800 | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 | 0.5
PW894 | 2020-04-03 00:00:00 | 2020-07-08 00:00:00 | 93
PW888 | 2020-04-03 00:00:00 | 2020-05-10 00:00:00 | 35
PW888 | 2020-05-16 00:00:00 | 2020-07-09 00:00:00 | 54
PW888 | 2020-07-18 00:00:00 | 2020-07-31 00:00:00 | 14
PW890 | 2020-04-03 00:00:00 | 2020-06-25 00:00:00 | 80
PW890 | 2020-07-03 00:00:00 | 2020-07-31 00:00:00 | 29
PW1004 | 2020-04-20 00:00:00 | 2020-07-31 00:00:00 | 101
PW137 | 2020-04-03 00:00:00 | 2020-04-29 00:00:00 | 25
PW137 | 2020-05-05 00:00:00 | 2020-06-25 00:00:00 | 50
PW137 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 32
PW866 | 2020-04-03 00:00:00 | 2020-06-16 00:00:00 | 71
PW1048 | 2020-04-03 00:00:00 | 2020-04-23 00:00:00 | 19
PW1048 | 2020-04-25 00:00:00 | 2020-06-16 00:00:00 | 51
PW1044 | 2020-05-04 00:00:00 | 2020-06-16 00:00:00 | 42
PW873 | 2020-04-03 00:00:00 | 2020-06-16 00:00:00 | 71
PW878 | 2020-04-03 00:00:00 | 2020-05-11 00:00:00 | 36
[NAME] | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW882 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW870 | 2020-05-04 00:00:00 | 2020-06-16 00:00:00 | 42
PW874 | 2020-04-03 00:00:00 | 2020-06-16 00:00:00 | 71
[NAME] | 2020-04-03 00:00:00 | 2020-06-25 00:00:00 | 80
[NAME] | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 32
PW864 | 2020-05-04 00:00:00 | 2020-06-16 00:00:00 | 42
PW785 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1121 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
[NAME] | 2020-04-03 00:00:00 | 2020-05-31 00:00:00 | 55
PW969 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1063 | 2020-04-03 00:00:00 | 2020-04-07 00:00:00 | 5
PW1063 | 2020-04-10 00:00:00 | 2020-07-31 00:00:00 | 109
PW1036 | 2020-04-13 00:00:00 | 2020-06-30 00:00:00 | 76
PW1036 | 2020-07-13 00:00:00 | 2020-07-13 00:00:00 | 1
PW1036 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2
PW1036 | 2020-07-20 00:00:00 | 2020-07-20 00:00:00 | 1
PW1036 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2
PW1036 | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | 1
PW1036 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2
PW1052 | 2020-04-03 00:00:00 | 2020-05-31 00:00:00 | 55
PW1046 | 2020-04-03 00:00:00 | 2020-06-14 00:00:00 | 69
PW1128 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW903 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW897 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1090 | 2020-04-06 00:00:00 | 2020-06-22 00:00:00 | 74
PW1090 | 2020-07-01 00:00:00 | 2020-07-12 00:00:00 | 12
PW1090 | 2020-07-18 00:00:00 | 2020-07-31 00:00:00 | 14
PW1045 | 2020-04-03 00:00:00 | 2020-06-21 00:00:00 | 76
[NAME] | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW912 | 2020-04-03 00:00:00 | 2020-06-08 00:00:00 | 63
PW996 | 2020-04-03 00:00:00 | 2020-06-04 00:00:00 | 59
PW996 | 2020-06-09 00:00:00 | 2020-07-31 00:00:00 | 53
PW1074 | 2020-04-30 00:00:00 | 2020-07-31 00:00:00 | 93
PW10 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW936 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW1066 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW1066 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW1066 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW1066 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW1066 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW1066 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
[NAME] | 2020-04-03 00:00:00 | 2020-05-10 00:00:00 | 35
[NAME] | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
[NAME] | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
[NAME] | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
[NAME] | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
[NAME] | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW933 | 2020-04-03 00:00:00 | 2020-06-04 00:00:00 | 59
PW933 | 2020-06-06 00:00:00 | 2020-06-30 00:00:00 | 25
PW933 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW933 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW933 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW933 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW933 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW1187 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1028 | 2020-04-04 00:00:00 | 2020-04-23 00:00:00 | 18
PW1028 | 2020-04-25 00:00:00 | 2020-07-31 00:00:00 | 96
PW1080 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1183 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1189 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW926 | 2020-04-14 00:00:00 | 2020-05-03 00:00:00 | 20
PW926 | 2020-05-05 00:00:00 | 2020-05-21 00:00:00 | 16
PW926 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2
PW926 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2
PW926 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2
PW926 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2
PW926 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2
PW926 | 2020-04-06 00:00:00 | 2020-06-30 00:00:00 | 82
PW849 | 2020-04-20 00:00:00 | 2020-05-25 00:00:00 | 34
PW849 | 2020-05-30 00:00:00 | 2020-07-05 00:00:00 | 37
PW849 | 2020-07-08 00:00:00 | 2020-07-10 00:00:00 | 3
PW849 | 2020-07-15 00:00:00 | 2020-07-17 00:00:00 | 3
PW849 | 2020-07-22 00:00:00 | 2020-07-24 00:00:00 | 3
PW849 | 2020-07-29 00:00:00 | 2020-07-31 00:00:00 | 3
PW1092 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1086 | 2020-04-06 00:00:00 | 2020-06-02 00:00:00 | 54
PW1086 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW1086 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW1086 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW1086 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW1086 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW855 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW855 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW855 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW855 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW855 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW855 | 2020-04-13 00:00:00 | 2020-06-30 00:00:00 | 76
PW858 | 2020-04-03 00:00:00 | 2020-06-02 00:00:00 | 57
PW858 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW858 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW858 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW858 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW858 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW1110 | 2020-04-03 00:00:00 | 2020-04-26 00:00:00 | 22
PW953 | 2020-04-03 00:00:00 | 2020-04-29 00:00:00 | 25
PW1000 | 2020-04-06 00:00:00 | 2020-07-31 00:00:00 | 113
PW999 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1087 | 2020-04-03 00:00:00 | 2020-05-10 00:00:00 | 35
PW1096 | 2020-04-03 00:00:00 | 2020-07-01 00:00:00 | 86
PW1041 | 2020-04-06 00:00:00 | 2020-05-18 00:00:00 | 40
PW1071 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW1071 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 1
PW1071 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2
PW1071 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2
PW1071 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2
PW1071 | 2020-07-28 00:00:00 | 2020-07-29 00:00:00 | 2
PW845 | 2020-04-13 00:00:00 | 2020-07-31 00:00:00 | 107
PW1127 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 84.25
PW1137 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 84.25
PW944 | 2020-04-06 00:00:00 | 2020-06-04 00:00:00 | 56
PW944 | 2020-06-06 00:00:00 | 2020-06-14 00:00:00 | 9
PW1200 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW1200 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW1200 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW1200 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW1200 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW1200 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW1201 | 2020-04-10 00:00:00 | 2020-04-15 00:00:00 | 3
PW1206 | 2020-07-01 00:00:00 | 2020-07-03 00:00:00 | 3
PW1206 | 2020-07-06 00:00:00 | 2020-07-10 00:00:00 | 5
PW1206 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2
PW1206 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2
PW1206 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2
PW1209 | 2020-04-03 00:00:00 | 2020-06-16 00:00:00 | 71
PW1213 | 2020-07-01 00:00:00 | 2020-07-03 00:00:00 | 3
PW1213 | 2020-07-08 00:00:00 | 2020-07-10 00:00:00 | 3
PW1213 | 2020-07-15 00:00:00 | 2020-07-17 00:00:00 | 3
PW1213 | 2020-07-22 00:00:00 | 2020-07-24 00:00:00 | 3
PW1213 | 2020-07-29 00:00:00 | 2020-07-31 00:00:00 | 3
PW1213 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW1216 | 2020-04-10 00:00:00 | 2020-07-31 00:00:00 | 109
PW1232 | 2020-04-06 00:00:00 | 2020-05-31 00:00:00 | 52
PW1238 | 2020-07-03 00:00:00 | 2020-07-03 00:00:00 | 1
PW1238 | 2020-07-10 00:00:00 | 2020-07-10 00:00:00 | 1
PW1238 | 2020-07-17 00:00:00 | 2020-07-17 00:00:00 | 1
PW1238 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | 1
PW1238 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 1
PW1238 | 2020-04-03 00:00:00 | 2020-06-30 00:00:00 | 85
PW1241 | 2020-04-03 00:00:00 | 2020-07-31 00:00:00 | 116
PW1246 | 2020-04-22 00:00:00 | 2020-04-28 00:00:00 | 7
PW1257 | 2020-04-03 00:00:00 | 2020-07-17 00:00:00 | 102
PW1257 | 2020-07-21 00:00:00 | 2020-07-24 00:00:00 | 4
PW1257 | 2020-07-28 00:00:00 | 2020-07-31 00:00:00 | 4