Count Days / Exclude Weekends

[bobgrand]

Hello all,

Is there a formula to calculate the number of days and exclude weekend days. (Example. We put an order in on Friday. We should see it by Thursday. That is considered 4 working days. I tried using "WORKDAY" in the formula but for some reason it is counting Saturday and Sunday.)

Any help would be greatly appreciated.

Bob

 

[Fluff]

Maybe

+Fluff v2.xlsm
	A	B
1
2	30/10/2020	05/11/2020
Main

Cell Formulas
Range	Formula
B2	B2	=WORKDAY(A2,4)

 

[bobgrand]

Fluff, If I did your formula correctly I am not getting what I was hoping. Maybe my explanation wasn't detailed enough. In column C I need to see the number of days from Order Date to Receipt date and exclude weekend days. 10/05 to 10/13 is 8 days, Subtract Saturday and Sunday and the answer is 6.

 

[Fluff]

Ok, how about

=NETWORKDAYS(A2,B2)-1

 

[bobgrand]

That did it. Thank you so much Fluff Have a great day

 

[Fluff]

You're welcome & thanks for the feedback.