| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS FUNCTION, Help please | Excel Worksheet Functions | |||
| NETWORKDAYS FUNCTION, Help please | Excel Worksheet Functions | |||
| networkdays function help | Excel Worksheet Functions | |||
| MS Excel Function - Networkdays | Excel Worksheet Functions | |||
| Re-assigning weekend days in "Networkdays" Function | Excel Discussion (Misc queries) | |||
Linear Mode
