Calculation of Dates (workweeks)

[marshak]

Hello all!

I once again need your expertise. I need to calculate:

1. The total number of workweeks each of these people worked between 1/28/2017 and present.
2. The cumulative total number of workweeks all of these people worked between 1/28/2017 and present.
3. The total number of workweeks each of these people worked between 1/28/2020 and present.
4. The cumulative total number of workweeks all of these people worked between 1/28/2020 and present.

I do not know where to begin to get these calculations done. Please help!

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

 

[Anthony47]

Assuming that Start and Termination dates are in column C & D, from row 3.
You put in F1 the date Jan 28 2017 and in F2 the current date; in G1 the date Jan 28 2018 and G2 again the current date
Now use in F3 the formula =(1-MAX($C3,F$1)+MIN($D3,F$2))/7
Format as number with 2 decimals, then copy F3 to G3, then copy downward

This will give for each Name the number of weeks (ie, period of 7 days) in between the dates

Don't know if you have a different definition for "Week"...