Counting NetworkDays (2 or Less) for week Commencing...

[surkdidat]

Hi (again!)

I need to calculate the number of NETWORKDAYS (between Column G / Column Q) and combine with COUNTIF for

2 days or less
3-4 days
5-8 days

So,

in the below Table it counts

Tier 1 - ONE (as one date falls outside the range)
Tier 2 - TWO (as both Tier 2's fall inside date range)

Col G (Start Date)	Col Q (End Date)	Col R (Tier)
18/10/21	19/10/21	Tier 1 (2 Days or Less)
18/10/21	22/10/21	Tier 1 (2 Days or Less)
18/10/21	19/10/21	Tier 2 (3-4 Days)
18/10/21	22/10/21	Tier 2 (3-4 Days)

Thanks

 

[etaf]

maybe if i understand combine with a IF()
But 18/10/21 to 22/10/21 - why is that < = 2 days

=IF( NETWORKDAYS(A2,B2) <=2, "Tier 1 (2 days or less)", IF( NETWORKDAYS(A2,B2) <=4,"Tier 2 (3-4 days)", "Tier 3 (> 4 days)"))

Book2
	A	B	C	D	E
1	Col G (Start Date)	Col Q (End Date)	Col R (Tier)	Networkdays
2	10/18/21	10/19/21	Tier 1 (2 Days or Less)	2	Tier 1 (2 days or less)
3	10/18/21	10/22/21	Tier 1 (2 Days or Less)	5	Tier 3 (> 4 days)
4	10/18/21	10/19/21	Tier 2 (3-4 Days)	2	Tier 1 (2 days or less)
5	10/18/21	10/22/21	Tier 2 (3-4 Days)	5	Tier 3 (> 4 days)
Sheet3

Cell Formulas
Range	Formula
D2:D5	D2	=NETWORKDAYS(A2,B2)
E2:E5	E2	=IF( NETWORKDAYS(A2,B2) <=2, "Tier 1 (2 days or less)", IF( NETWORKDAYS(A2,B2) <=4,"Tier 2 (3-4 days)", "Tier 3 (> 4 days)"))