While using networkdays function, how can define weekly off days

F

faisalm

Excel count weekly off Saturday & Friday. But my case it is Friday &
Saturday. I want to define that while using networkdays and workday functions.

Please help.

Regards
 
B

Bob Phillips

I think you mean that the days off should be Friday and Saturday, not
Saturday and Sunday, if so then use

=NETWORKDAYS(start_date+1,end_date+1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top