View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default While using networkdays function, how can define weekly off days

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)

"faisalm" wrote in message
...
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