While using networkdays function, how can define weekly off days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top