Spreadsheet: 844944d1696534139-need-help-with-a-date-and-time-off-calculation-formula-two-parts-book3
Sheet: NEW BID

 | F |  |  |  |  |  |  |  |  | Description | VAC CHART LISTING SORTED | All Possible depts.
REBID OF WAREHOUSE EFFECTIVE November 3, 2019 |  |  |  |  |  |  |  |  |  | GROC WHSE 1ST | C61C-2
Updated: | 2023-10-02 00:00:00 |  |  |  |  |  |  |  |  | GROC WHSE 1ST | C61C-3
NO. | EMPLOYEE | SEN. ORDER | Combined Dept./Sched | Adjusted Seniority Date | Alt Date |  |  |  |  | GROC WHSE 1ST | C61C-5
565 | [NAME] | J | C65L-K | 2017-03-26 00:00:00 |  |  |  |  |  | GROC WHSE 1ST | C61C-6
963 | [NAME] |  | C61C-T | 03/12/1986 |  |  |  |  |  | GROC WHSE 1ST | C61C-7
542 | [NAME] 3 | A | C65L-3 | 2016-12-18 00:00:00 |  |  |  |  |  | GROC WHSE 1ST | C61C-A
247 | [NAME] 4 | G | C61C-A | 2020-10-11 00:00:00 |  |  |  |  |  | GROC WHSE 1ST | C61C-B
422 | [NAME] | A | C61QJ-1 | 10/10/1979 |  |  |  |  |  | GROC WHSE 1ST | C61C-G
980 | [NAME] 6 |  | C67G-0 | 04/28/1986 |  |  |  |  |  | GROC WHSE 1ST | C61CJ-B
336 | [NAME] 7 | E | C61C-7 | 2016-03-13 00:00:00 |  |  |  |  |  | GROC WHSE 1ST | C61C-M
337 | [NAME] 8 |  | C61Q-1 | 03/12/1989 |  |  |  |  |  | GROC WHSE 1ST | C61C-R
415 | [NAME] 9 |  | C65L-B | 10/03/1979 |  |  |  |  |  | GROC WHSE 1ST | C61C-S
312 | [NAME] 10 |  | C65L-5 | 07/29/1990 |  |  |  |  |  | GROC WHSE 1ST | C61C-T
871 | [NAME] 11 | A | C65L-5 | 2019-04-28 00:00:00 |  |  |  |  |  | GROC WHSE 1ST | C61C-U
500 | [NAME] 12 |  | C65L-B | 04/30/1987 |  |  |  |  |  | GROC WHSE 3RD | C61Q-0
261 | [NAME] 13 |  | C61C-3 | 10/02/1988 |  |  |  |  |  | GROC WHSE 3RD | C61Q-1
310 | [NAME] 14 | E | C61C-A | 2021-01-10 00:00:00 |  |  |  |  |  | GROC WHSE 3RD | C61Q-8
375 | [NAME] 15 |  | C61QJ-1 | 03/30/1989 |  |  |  |  |  | GROC WHSE 3RD | C61QJ-1
298 | [NAME] 16 | A | C61C-7 | 11/10/1988 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-3
250 | [NAME] 17 |  | [NAME] | 09/20/1988 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-5
266 | [NAME] 18 | A | C61C-G | 2020-10-25 00:00:00 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-B
699 | [NAME] 19 | B | C65L-5 | 2018-03-25 00:00:00 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-F
812 | [NAME] 20 |  | C65L-F | 05/07/1993 |  |  |  |  |  | DAIRY [NAME] 1ST | C65DJ-B
678 | [NAME] 21 | B | C61C-B | 12/07/1987 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-K
688 | [NAME] 22 | H | C61C-T | 2011-06-21 00:00:00 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-P
111 | [NAME] 23 |  | C61Q-0 | 09/28/1977 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-Q
724 | [NAME] 24 |  | C61Q-1 | 10/02/1992 |  |  |  |  |  | DAIRY [NAME] 1ST | C65D-R
883 | [NAME] 25 | I | C65L-5 | 2014-10-19 00:00:00 |  |  |  |  |  | PERISH WHSE 1ST | C65F-P
5 | [NAME] 26 |  | C61QJ-1 | 03/22/1983 |  |  |  |  |  | PERISH WHSE 2ND | C65L-2
209 | [NAME] 27 |  | C65L-B | 09/28/1981 |  |  |  |  |  | PERISH WHSE 2ND | C65L-3
913 | [NAME] 28 | E | C65D-P | 2019-06-16 00:00:00 |  |  |  |  |  | PERISH WHSE 2ND | C65L-5
163 | [NAME] 29 |  | C65D-R | 01/29/1978 |  |  |  |  |  | PERISH WHSE 2ND | C65L-6
897 | [NAME] 30 | C | C65L-5 | 2019-04-28 00:00:00 |  |  |  |  |  | PERISH WHSE 2ND | C65L-7
94 | [NAME] 31 |  | C65L-B | 02/16/1981 |  |  |  |  |  | PERISH WHSE 2ND | C65L-B
191 | [NAME] 32 | J | C61C-A | 2020-09-06 00:00:00 |  |  |  |  |  | PERISH WHSE 2ND | C65L-C
318 | [NAME] 33 | D | C61C-A | 2021-01-10 00:00:00 |  |  |  |  |  | PERISH WHSE 2ND | C65L-F
721 | [NAME] 34 | B | C65L-5 | 2018-04-22 00:00:00 |  |  |  |  |  | PERISH WHSE 2ND | C65LJ-B
119 | [NAME] 35 |  | C61Q-1 | 10/17/1977 |  |  |  |  |  | PERISH WHSE 2ND | C65L-K
610 | [NAME] 36 | A | C61Q-1 | 08/19/1987 |  |  |  |  |  | PERISH WHSE 2ND | C65L-Q
472 | [NAME] 37 |  | C65S-1 | 06/26/1989 |  |  |  |  |  | PERISH WHSE 2ND | [NAME]
195 | [NAME] 38 | A | C61C-M | 2015-06-28 00:00:00 |  |  |  |  |  | DAIRY WHSE 3RD | C65S-1
80 | [NAME] 39 |  | C65D-Q | 02/02/1981 |  |  |  |  |  | PERISH WHSE 3RD | C67G-0
545 | [NAME] 40 | A | C61Q-1 | 09/22/1980 |  |  |  |  |  | PERISH WHSE 3RD | C67G-1
916 | [NAME] 41 |  | C65D-3 | 12/04/1985 |  |  |  |  |  | PERISH WHSE 3RD | C67GJ-1
112 | [NAME] 42 |  | C65D-B | 09/08/1970 |  |  |  |  |  | MAINTENANCE | S61KM-1
896 | [NAME] 43 |  | C65L-5 | 10/26/1993
20 | [NAME] 44 |  | C61Q-1 | 09/17/1976
847 | [NAME] 45 | C | C61C-7 | 2019-01-06 00:00:00
773 | [NAME] 46 |  | C61C-B | 07/11/1985
253 | [NAME] 47 |  | C61C-B | 01/05/1979
879 | [NAME] 48 | E | C65L-K | 2014-10-19 00:00:00
978 | [NAME] 49 | A | C65L-5 | 2020-01-12 00:00:00
617 | [NAME] 50 |  | C61C-3 | 10/23/1984
512 | [NAME] 51 | J | C61C-7 | 2016-11-13 00:00:00
977 | [NAME] 52 | D | C65L-F | 2020-01-12 00:00:00
449 | [NAME] 53 | C | C61C-7 | 2016-08-28 00:00:00
740 | [NAME] 54 |  | C67GJ-1 | 04/12/1985
734 | [NAME] 55 | A | C65L-K | 2018-04-22 00:00:00
951 | [NAME] 56 | B | C65D-K | 2015-02-22 00:00:00
212 | [NAME] 57 | A | C61C-T | 07/05/1988
166 | [NAME] 58 |  | C65L-Q | 08/24/1977
541 | [NAME] 59 |  | C65LJ-B | 09/15/1980
53 | [NAME] 60 |  | C61C-U | 2020-04-19 00:00:00
557 | [NAME] 61 |  | C61Q-1 | 10/26/1989
275 | [NAME] 62 | C | C61C-G | 2020-11-08 00:00:00
508 | [NAME] 63 | E | C65D-Q | 2011-06-21 00:00:00
301 | [NAME] 64 |  | C65L-6 | 11/15/1988
873 | [NAME] 65 | A | C65D-F | 2014-10-19 00:00:00
168 | [NAME] 66 |  | C65L-5 | 2013-07-31 00:00:00
374 | [NAME] 67 | A | [NAME] | 10/28/1986
530 | [NAME] 68 |  | C61Q-1 | 11/24/1991
155 | [NAME] 69 | C | C61C-A | 2020-08-02 00:00:00
756 | [NAME] 70 | A | C61C-7 | 2018-06-29 00:00:00
207 | [NAME] 71 | A | C65L-3 | 2015-08-09 00:00:00
265 | [NAME] 72 | B | C61C-A | 2020-10-25 00:00:00
426 | [NAME] 73 |  | C61C-5 | 05/16/1989
285 | [NAME] 74 |  | C61Q-0 | 05/15/1979
276 | [NAME] 75 |  | C65L-B | 09/17/1981
681 | [NAME] 76 |  | C65S-1 | 07/07/1992
295 | [NAME] 77 | B | C67GJ-1 | 11/10/1988
86 | [NAME] 78 | B | C65L-5 | 2020-06-21 00:00:00
274 | [NAME] 79 | E | C61C-G | 2020-11-08 00:00:00
383 | [NAME] 80 |  | C61C-B | 08/28/1979
570 | [NAME] 81 | G | C65L-K | 2017-03-19 00:00:00
864 | [NAME] 82 | L | C61C-T | 2014-10-12 00:00:00
725 | [NAME] 83 |  | C65S-1 | 03/01/1988
531 | [NAME] 84 |  | C61Q-1 | 03/20/1992
256 | [NAME] 85 |  | C67G-1 | 09/27/1988
658 | [NAME] 86 |  | C61C-3 | 10/26/1987
575 | [NAME] 87 | M | C65L-K | 2017-04-16 00:00:00
363 | [NAME] 88 |  | C61Q-1 | 10/19/1986
482 | [NAME] 89 | S | C65L-K | 2016-09-18 00:00:00
234 | [NAME] 90 |  | C65F-P | 07/09/1986
139 | [NAME] 91 | B | C61C-3 | 2015-05-10 00:00:00
534 | [NAME] 92 |  | C61C-3 | 09/09/1980
891 | [NAME] 93 | D | C61C-3 | 2014-11-02 00:00:00
373 | [NAME] 94 | A | C65D-5 | 2016-06-05 00:00:00
371 | [NAME] 95 |  | C65L-B | 08/14/1979
627 | [NAME] 96 |  | C67G-1 | 09/03/1987
324 | [NAME] 97 |  | C65L-5 | 12/04/1988
739 | [NAME] 98 | B | C67G-1 | 10/15/1992
258 | [NAME] 99 | A | C65L-5 | 2015-10-25 00:00:00
433 | [NAME] 100 | C | C65D-5 | 2016-08-21 00:00:00
175 | [NAME] 101 | B | C65L-C | 2020-08-30 00:00:00
515 | [NAME] 102 |  | C65D-B | 07/08/1980
330 | [NAME] 103 |  | C67G-1 | 11/10/1981
695 | [NAME] 104 |  | C61C-T | 02/09/1985
955 | [NAME] 105 | A | C65L-5 | 2019-11-10 00:00:00
912 | [NAME] 106 | A | C61Q-8 | 11/18/1985
887 | [NAME] 107 | A | C61C-3 | 2014-11-02 00:00:00
945 | [NAME] 108 | B | C61C-3 | 2015-02-08 00:00:00
240 | [NAME] 109 |  | C67GJ-1 | 07/18/1986
621 | [NAME] 110 | A | C67GJ-1 | 08/31/1987
448 | [NAME] 111 | B | C61C-7 | 2016-08-28 00:00:00
984 | [NAME] 112 |  | C65L-6 | 05/16/1986
736 | [NAME] 113 | B | C65L-6 | 2014-07-10 00:00:00
326 | [NAME] 114 |  | C61Q-1 | 12/06/1988
566 | [NAME] 115 |  | C61C-B | [NAME]
703 | [NAME] 116 |  | C61QJ-1 | 01/11/1988
603 | [NAME] 117 |  | C61Q-0 | 08/07/1987
975 | [NAME] 118 |  | C65D-K | 2012-01-27 00:00:00
381 | [NAME] 119 |  | C65L-3 | 2013-06-03 00:00:00
208 | [NAME] 120 | A | C61C-A | 2020-09-27 00:00:00
702 | [NAME] 121 |  | C65L-7 | 01/04/1988
386 | [NAME] 122 |  | C65S-1 | 04/19/1989
57 | [NAME] 123 |  | C61C-B | 11/22/1976
58 | [NAME] 124 |  | C61CJ-B | 02/10/1976
501 | [NAME] 125 | B | C65D-5 | 2016-10-02 00:00:00
322 | [NAME] 126 | B | C61C-G | 2021-01-10 00:00:00
715 | [NAME] |  | C61Q-1 | 04/17/1990
652 | [NAME] 128 | F | C65L-5 | 2011-06-21 00:00:00
228 | [NAME] 129 | I | C61C-7 | 2015-09-13 00:00:00
668 | [NAME] 130 |  | C67GJ-1 | 01/03/1985
317 | [NAME] 131 | C | C61C-G | 2021-01-10 00:00:00
524 | [NAME] 132 | F | C61C-7 | 2016-12-04 00:00:00
216 | [NAME] 133 | B | C65L-7 | 2020-10-04 00:00:00
952 | [NAME] 134 | A | C61C-7 | 02/17/1986
280 | [NAME] 135 |  | C67G-1 | 10/05/1981
164 | [NAME] 136 | D | C65D-F | 2020-08-30 00:00:00
65 | [NAME] 137 |  | C61Q-0 | 06/04/1975
107 | [NAME] 138 | B | C65L-6 | 2015-03-29 00:00:00
316 | [NAME] 139 |  | C65DJ-B | 11/15/1982
693 | [NAME] 140 |  | C67G-1 | 02/08/1985
684 | [NAME] 141 |  | C61CJ-B | 01/09/1985
687 | [NAME] 142 | C | C61C-5 | 2018-02-18 00:00:00
68 | [NAME] 143 |  | C61C-B | 02/03/1976
224 | [NAME] 144 | A | C65L-B | 11/22/1982
842 | [NAME] 145 | C | C65L-5 | 2018-12-09 00:00:00
174 | [NAME] 146 | A | C61C-G | 2020-08-30 00:00:00
450 | [NAME] 147 |  | C61C-3 | 03/13/1984
172 | [NAME] 148 | D | C65D-F | 2020-08-30 00:00:00
305 | [NAME] 149 | H | C61C-G | 2021-01-10 00:00:00
877 | [NAME] 150 |  | C61C-B | 11/15/1985
343 | [NAME] 151 |  | C61C-B | 07/20/1979
214 | [NAME] 152 | D | C61C-A | 2020-09-27 00:00:00
648 | [NAME] 153 |  | C65L-K | 10/08/1987
283 | [NAME] 154 |  | C61Q-1 | 05/16/1979
408 | [NAME] 155 | A | C61C-U | 2016-07-31 00:00:00
399 | [NAME] 156 |  | C67G-1 | 11/19/1986
239 | [NAME] 157 | A | C61C-5 | 2015-10-18 00:00:00
235 | [NAME] 158 |  | C65L-B | 08/21/1988
199 | [NAME] 159 |  | C61Q-1 | 06/20/1988
279 | [NAME] 160 |  | C61C-B | 08/20/1986
495 | [NAME] 161 | C | C65D-K | 2016-09-18 00:00:00
701 | [NAME] 162 |  | C65LJ-B | 02/20/1985
284 | [NAME] 163 | A | C61C-G | 2020-11-08 00:00:00
567 | [NAME] 164 |  | C61C-S | 03/11/1981
268 | [NAME] 165 | C | C61C-G | 2020-10-25 00:00:00
184 | [NAME] 166 |  | C65D-B | 10/06/1975
911 | [NAME] | B | C61Q-8 | 11/18/1985
571 | [NAME] 168 | O | C65L-K | 2017-04-16 00:00:00
416 | [NAME] 169 |  | C61QJ-1 | 10/08/1979
953 | [NAME] 170 | C | C65D-P | 2015-02-22 00:00:00
432 | [NAME] 171 |  | C67G-1 | 05/21/1989
445 | [NAME] 172 |  | C61C-B | 11/15/1979
304 | [NAME] 173 |  | C61QJ-1 | 06/12/1979
746 | [NAME] |  | C61C-R | 04/09/1985
314 | [NAME] 175 |  | C61Q-1 | 06/21/1993
220 | [NAME] 176 | E | C61C-T | 2015-09-13 00:00:00
446 | [NAME] 177 | B | C61Q-1 | [NAME]
327 | [NAME] 178 | I | C65L-F | 2016-02-14 00:00:00
780 | [NAME] 179 | C | C65F-P | 2011-06-21 00:00:00
465 | [NAME] 180 | I | C65L-6 | 2016-08-28 00:00:00
349 | [NAME] 181 |  | C61Q-1 | 07/31/1979
131 | [NAME] 182 |  | C65D-B | 06/07/1977
186 | [NAME] 183 | D | C65L-2 | 2020-09-06 00:00:00
878 | [NAME] 184 |  | [NAME] | 11/17/1985
453 | [NAME] 185 | L | C65L-6 | 2016-08-28 00:00:00
237 | [NAME] 186 |  | C61C-5 | 08/18/1988
772 | [NAME] 187 | A | C61Q-8 | 07/08/1985
552 | [NAME] 188 |  | C61Q-1 | 07/30/1989
428 | [NAME] 189 |  | C61Q-1 | 10/17/1979
629 | [NAME] 190 |  | C65L-3 | 02/08/1990
293 | [NAME] 191 | D | C61C-U | 2016-01-10 00:00:00
46 | [NAME] 192 | A | C65L-7 | 2020-01-26 00:00:00
722 | [NAME] 193 |  | C67G-1 | 07/19/1990
704 | [NAME] 194 |  | C65L-B | 03/19/1990
606 | [NAME] 195 | A | C61C-7 | 2014-03-07 00:00:00
474 | [NAME] 196 | B | C61C-5 | 2016-09-18 00:00:00
263 | [NAME] 197 | A | C61C-G | 2020-10-25 00:00:00
334 | [NAME] 198 |  | C67G-1 | 05/22/1992
749 | [NAME] 199 | B | C65LJ-B | 07/08/1985
858 | [NAME] 200 | H | C61C-5 | 2014-10-12 00:00:00
637 | [NAME] 201 |  | [NAME] | 09/20/1987
458 | [NAME] 202 |  | C61C-U | 2013-07-02 00:00:00
642 | [NAME] 203 |  | C61C-6 | 2014-05-23 00:00:00
949 | [NAME] 204 | B | C61QJ-1 | 02/17/1986
273 | [NAME] 205 |  | C67G-1 | 10/18/1988
269 | [NAME] 206 |  | C67G-1 | 08/12/1986
197 | [NAME] 207 | B | C65D-3 | 2015-06-28 00:00:00
267 | [NAME] 208 |  | [NAME] | 10/05/1988
320 | [NAME] 209 |  | C65L-B | 11/30/1988
400 | [NAME] 210 |  | C65D-B | 09/18/1979
742 | [NAME] 211 |  | [NAME] | 05/14/1990
118 | [NAME] 212 |  | C61Q-1 | 10/10/1977
417 | [NAME] 213 | F | C65F-P | 2016-08-07 00:00:00
590 | [NAME] 214 |  | C67G-1 | 07/20/1987
434 | [NAME] 215 |  | C65D-5 | 01/28/1987
210 | [NAME] 216 | B | C65L-3 | 2011-06-21 00:00:00
407 | [NAME] 217 | D | C65L-7 | 2011-06-21 00:00:00
289 | [NAME] 218 | A | C61C-G | 2021-01-10 00:00:00
114 | [NAME] 219 | A | C61C-5 | 2015-04-12 00:00:00
47 | [NAME] 220 | D | C61C-U | 2020-04-05 00:00:00
380 | [NAME] 221 | A | C67G-1 | 08/27/1979
833 | [NAME] 222 |  | C65L-3 | 09/11/1987
303 | [NAME] 223 | I | C61C-G | 2021-01-10 00:00:00
986 | [NAME] 224 |  | C67G-1 | 10/09/1991
78 | [NAME] 225 | B | C67G-1 | 06/23/1986
882 | [NAME] 226 | H | C61C-2 | 2014-10-19 00:00:00
233 | [NAME] 227 | C | C61C-A | 2020-10-11 00:00:00
605 | [NAME] 228 |  | C65D-5 | 08/12/1987
102 | [NAME] 229 |  | C61Q-1 | 07/05/1977
503 | [NAME] 230 |  | C65S-1 | 09/03/1989
259 | [NAME] 231 | E | C65L-6 | 2015-10-25 00:00:00
183 | [NAME] 232 | B | C65L-2 | 2020-09-06 00:00:00
395 | [NAME] 233 | G | C65L-3 | 2016-07-10 00:00:00
840 | [NAME] 234 | C | C65D-3 | 2014-10-12 00:00:00
942 | [NAME] 235 | C | C65L-5 | 2019-09-08 00:00:00
230 | [NAME] 236 |  | C65L-B | 08/16/1988
519 | [NAME] 237 |  | C65L-F | 2013-12-29 00:00:00
562 | [NAME] 238 | B | C61C-B | 03/02/1981
366 | [NAME] 239 |  | C61C-5 | 2013-02-27 00:00:00
421 | [NAME] 240 | B | C65L-5 | 2016-08-14 00:00:00
109 | [NAME] 241 |  | C61C-3 | 10/12/1977
132 | [NAME] 242 |  | C67G-0 | 03/19/1978
370 | [NAME] 243 |  | C61CJ-B | 11/12/1980
244 | [NAME] 244 |  | C65L-B | 02/05/1983
300 | [NAME] |  | C61Q-1 | 11/13/1988
604 | [NAME] 246 |  | C65D-P | 12/07/1989
8010 | [NAME] 247 |  | S61KM-1 | 1980-06-02 00:00:00 | 1980-06-02 00:00:00
8003 | [NAME] 248 |  | S61KM-1 | 1981-06-22 00:00:00 | 1981-06-22 00:00:00
8007 | [NAME] 249 |  | S61KM-1 | 1985-07-29 00:00:00 | 1985-07-29 00:00:00
8004 | [NAME] 250 |  | S61KM-1 | 2003-10-20 00:00:00 | 2003-10-20 00:00:00
8023 | [NAME] 251 |  | S61KM-1 | 2012-12-11 00:00:00 | 2012-12-11 00:00:00
8028 | [NAME] 252 |  | S61KM-1 | 2014-09-07 00:00:00 | 2014-09-07 00:00:00
8030 | [NAME] 253 |  | S61KM-1 | 2015-10-05 00:00:00 | 2015-10-05 00:00:00
8648 | [NAME] 254 |  | S61KM-1 | 2018-03-12 00:00:00 | 2018-03-12 00:00:00
391 | [NAME] 255 |  | S61KM-1 | 2019-02-24 00:00:00 | 2016-07-10 00:00:00
8034 | [NAME] 256 |  | S61KM-1 | 2019-04-01 00:00:00 | 2019-04-01 00:00:00
246 | [NAME] 257 |  | S61KM-1 | 2019-07-28 00:00:00 | 2015-10-11 00:00:00
655 | [NAME] 258 |  | S61KM-1 | 2021-08-05 00:00:00 | 2021-08-05 00:00:00