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
|