Hello all!
I once again need your expertise. I need to calculate:
Thank you in advance!!
I once again need your expertise. I need to calculate:
- The total number of workweeks each of these people worked between 1/28/2017 and present.
- The cumulative total number of workweeks all of these people worked between 1/28/2017 and present.
- The total number of workweeks each of these people worked between 1/28/2020 and present.
- The cumulative total number of workweeks all of these people worked between 1/28/2020 and present.
Thank you in advance!!
First Name | Last Name | Start Date | Termination Date | |||||
ALICE | ACUNA | 02/22/18 | 10/10/19 | |||||
ANA | AGREDANO | 01/16/12 | 03/25/22 | |||||
JAVIER | ALATORRE | 03/25/13 | 02/28/18 | |||||
KENNY | AU | 02/16/10 | 03/25/22 | |||||
JAVIER | AYALA | 12/01/14 | 03/25/22 | |||||
HECTOR | BARRERA | 09/16/19 | 02/26/20 | |||||
MICHAEL | BENSON | 07/20/15 | 05/03/19 | |||||
DAVID | BLACKMORE | 09/27/10 | 05/28/20 | |||||
ON | BLANCHARD | 12/10/01 | 02/22/19 | |||||
BINH | DINH | 04/09/19 | 01/20/21 | |||||
JOSE | DOMINGUEZ | 03/09/20 | 06/30/22 | |||||
EMERITO | DONADO | 09/15/97 | 02/18/22 | |||||
RONALD | DONGO | 08/20/19 | 09/17/20 | |||||
MOKHTAR | FAZLY | 11/26/18 | 02/18/22 | |||||
DONALD | FLEMING | 04/17/17 | 03/25/22 | |||||
EDNA | GULLIXSON | 07/22/20 | 09/15/21 | |||||
SALOMON | GUTIERREZ | 11/18/19 | 03/25/22 | |||||
MARCUS | HAMPTON | 09/30/19 | 08/03/20 | |||||
SANDRA | HERRERA | 01/04/99 | 03/25/22 | |||||
SANDRA | HORNER | 08/29/11 | 02/18/22 | |||||
TONY | HUYNH | 12/02/02 | 07/30/19 | |||||