| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WOrkday function - change working days
How do I define working days as Monday to Saturday for the Workday function ?
( instead of standard Monday to Friday |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WOrkday function - change working days
=WORKDAY(start_date,days)-SUMPRODUCT(--(WEEKDAY(ROW(INDEX($1:$65536,start_da
te,1):INDEX($1:$65536,WORKDAY(start_date,days),1)) )=1)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ashutosh" wrote in message ... How do I define working days as Monday to Saturday for the Workday function ? ( instead of standard Monday to Friday |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WOrkday function - change working days
I am not exactly sure what do I replace start_date and days with. If I replace start date with the date I want to start with and number of days as how many working days to add, it does not skip sundays. "Bob Phillips" wrote: =WORKDAY(start_date,days)-SUMPRODUCT(--(WEEKDAY(ROW(INDEX($1:$65536,start_da te,1):INDEX($1:$65536,WORKDAY(start_date,days),1)) )=1)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ashutosh" wrote in message ... How do I define working days as Monday to Saturday for the Workday function ? ( instead of standard Monday to Friday |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working days and hours calculation - request assistance please! | Excel Worksheet Functions | |||
| Getting XL to Calc Working Days Lost without using NETWORKDAYS() Function | Excel Discussion (Misc queries) | |||
| adding only working days to dates | Excel Discussion (Misc queries) | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| to use workday function in excel vba code | Excel Discussion (Misc queries) | |||
Linear Mode
