Excluding only friday use this formula

=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A18&":" &B18))),{6},0)),
1,0))/3

after entering the formula not just enter but use Ctrl + Shift + Enter




On Sep 10, 1:52*am, Jon wrote:
Greeting,

I have two cells A1 and B1 and A1 is the start date and B1 is End Date. What
I want to do is calculating the number of hours for workers which is 8 hours
per day. How to calculate the number of Hours excluding Friday.