Workdays between 2 days, summarised by week

[JW2989]

Hi,

I am trying to find the total workdays for my Project, summarised by week:

My project Start & End Date has 18 workdays.

Question - how do i plot the workdays in each week in COLUMNS I to M

WeeklyTest.xlsx
	D	E	F	G	H	I	J	K	L	M
3						January
4	Name	Project	Start	End	Workday	03/01/2022	10/01/2022	17/01/2022	24/01/2022	31/01/2022
5	Jon Beecher	Sales 2020	01/01/2022	26/01/2022	18
Sheet1

Cell Formulas
Range	Formula
H5	H5	=NETWORKDAYS(F5,G5)

 

[Phuoc]

Try this

Book1
	D	E	F	G	H	I	J	K	L	M
3						January
4	Name	Project	Start	End	Workday	03-01-2022	10-01-2022	17-01-2022	24-01-2022	31-01-2022
5	Jon Beecher	Sales 2020	01-01-2022	26-01-2022	18	1	5	5	5	2
Sheet1

Cell Formulas
Range	Formula
H5	H5	=NETWORKDAYS(F5,G5)
I5:M5	I5	=NETWORKDAYS(MAX($F5,I$4-6),MIN(I$4,$G5))

 

[JW2989]

Thank you!

 

[JW2989]

Try this

Book1
	D	E	F	G	H	I	J	K	L	M
3						January
4	Name	Project	Start	End	Workday	03-01-2022	10-01-2022	17-01-2022	24-01-2022	31-01-2022
5	Jon Beecher	Sales 2020	01-01-2022	26-01-2022	18	1	5	5	5	2
Sheet1

Cell Formulas
Range	Formula
H5	H5	=NETWORKDAYS(F5,G5)
I5:M5	I5	=NETWORKDAYS(MAX($F5,I$4-6),MIN(I$4,$G5))

How would I display "" for weeks when there is no workdays? I am currently getting lots of minus numbers in the weeks where projects are yet to start?

Thanks,

 

[Phuoc]

Change to:

=MAX(0,NETWORKDAYS(MAX($F5,I$4-6),MIN(I$4,$G5)))

 

[JW2989]

Try this

Book1
	D	E	F	G	H	I	J	K	L	M
3						January
4	Name	Project	Start	End	Workday	03-01-2022	10-01-2022	17-01-2022	24-01-2022	31-01-2022
5	Jon Beecher	Sales 2020	01-01-2022	26-01-2022	18	1	5	5	5	2
Sheet1

Cell Formulas
Range	Formula
H5	H5	=NETWORKDAYS(F5,G5)
I5:M5	I5	=NETWORKDAYS(MAX($F5,I$4-6),MIN(I$4,$G5))

Upon testing this does not work (I get 18 days but it is totalling each week wrong)

I have added what would be actually expected in the picture below:

 

[jtakw]

Hi,

How about this:

Book3.xlsx
	D	E	F	G	H	I	J	K	L	M
3						January
4	Name	Project	Start	End	Workday	1/3/2022	1/10/2022	1/17/2022	1/24/2022	1/31/2022
5	Jon Beecher	Sales 2020	1/1/2022	1/26/2022	18	5	5	5	3	0
6	Jack		1/14/2022	2/2/2022	14	0	1	5	5	3
7	Jane		1/15/2022	1/27/2022	9	0	0	5	4	0
Sheet953

Cell Formulas
Range	Formula
H5:H7	H5	=NETWORKDAYS(F5,G5)
I5:M7	I5	=MAX(NETWORKDAYS(MAX($F5,I$4),MIN($G5,I$4+6)),0)