dates between range including start and finish

[Afro_Cookie]

I've tried using =NETWORKDAYS and it does work, but it excludes the start and finish dates. Is there a method that will count weekdays in a range while including and the start and end in that range?

example:
Start date: July 8th, 2020
End date: July 15th, 2020
NETWORKDAYS: 4
Desired count: 6

 

[Fluff]

Networkdays returns 6 for me

+Fluff New.xlsm
	A
1
2	08/07/2020
3	15/07/2020
4	6
Main

Cell Formulas
Range	Formula
A4	A4	=NETWORKDAYS(A2,A3)

Have you included anything in the holidays argument?

 

[JoeMo]

If A1 holds the date 7/8/2020 and A2 the date 7/15/2020, then for me =NETWORDAYS(A1,A2) returns 6.

 

[Dave Patton]

How are you using Networkdays? It should give the correct results.
Please show your formula.

T202007a.xlsm
	C	D	E
1	Start	End	Workdays
2	Wed 08-Jul-20	Wed 15-Jul-20	6
3
2b

Cell Formulas
Range	Formula
E2	E2	=NETWORKDAYS(C2,D2)

 

[Afro_Cookie]

I fat eyed this and was looking at the wrong column/formula.

NETWORKDAYS works fine, it was the datedif() that was giving me off numbers, I've fixed that one by simply subtracting the dates and adding 1.

Thanks everyone for the support and responses!

How are you using Networkdays? It should give the correct results.
Please show your formula.

T202007a.xlsm
	C	D	E
1	Start	End	Workdays
2	Wed 08-Jul-20	Wed 15-Jul-20	6
3
2b

Cell Formulas
Range	Formula
E2	E2	=NETWORKDAYS(C2,D2)

If A1 holds the date 7/8/2020 and A2 the date 7/15/2020, then for me =NETWORDAYS(A1,A2) returns 6.

Networkdays returns 6 for me

+Fluff New.xlsm
	A
1
2	08/07/2020
3	15/07/2020
4	6
Main

Cell Formulas
Range	Formula
A4	A4	=NETWORKDAYS(A2,A3)

Have you included anything in the holidays argument?

 

[Fluff]

Glad we could help & thanks for the feedback.