Formula that will deduct 8 days in the total days for each month that occurs between 2 dates

[tonilrt]

I need formula that will deduct 8 days in the total days for each month that occurs between the start date and end date

Start Date​	End Date​	Total Days​
22/01/2020​	15/10/2020​	267​

 

[Fluff]

As the OP just wants to exclude weekends, you can just use networkdays, or networkdays.intl as I did.

+Fluff New.xlsm
	E	F	G	H
1	Start	End	Days
2	22/01/2020	15/10/2020	192	191
3	20/01/2020	11/10/2020	190	189
Main

Cell Formulas
Range	Formula
G2:G3	G2	=NETWORKDAYS.INTL(E2,F2,1)
H2:H3	H2	=(F2-E2)-(DAYS(F2,E2)+1-NETWORKDAYS(E2,F2))

 

[tonilrt]

Wh

As the OP just wants to exclude weekends, you can just use networkdays, or networkdays.intl as I did.

+Fluff New.xlsm
	E	F	G	H
1	Start	End	Days
2	22/01/2020	15/10/2020	192	191
3	20/01/2020	11/10/2020	190	189
Main

Cell Formulas
Range	Formula
G2:G3	G2	=NETWORKDAYS.INTL(E2,F2,1)
H2:H3	H2	=(F2-E2)-(DAYS(F2,E2)+1-NETWORKDAYS(E2,F2))

What’s the difference

As the OP just wants to exclude weekends, you can just use networkdays, or networkdays.intl as I did.

+Fluff New.xlsm
	E	F	G	H
1	Start	End	Days
2	22/01/2020	15/10/2020	192	191
3	20/01/2020	11/10/2020	190	189
Main

Cell Formulas
Range	Formula
G2:G3	G2	=NETWORKDAYS.INTL(E2,F2,1)
H2:H3	H2	=(F2-E2)-(DAYS(F2,E2)+1-NETWORKDAYS(E2,F2))

Hi. For the second formula, How come it’s showing up as “#NAME?”?

 

[Fluff]

When you say the second formula do you mean the one in H2?