ExcelBanter - While using networkdays function, how can define weekly off days

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - While using networkdays function, how can define weekly off days (https://www.excelbanter.com/excel-worksheet-functions/98563-while-using-networkdays-function-how-can-define-weekly-off-days.html)

faisalm

While using networkdays function, how can define weekly off days

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

Barb Reinhardt

While using networkdays function, how can define weekly off days

I'm not sure what you are asking. Please rephrase.

"faisalm" wrote:

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

Bob Phillips

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

All times are GMT +1. The time now is 08:05 AM.