| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Friday as weekend instead of Saturday & Sunday
in a Workday function, Saturday & Sunday is taken as weekend. How can I make
Friday as weekend instead of Sat & Sun |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Friday as weekend instead of Saturday & Sunday
Hi,
If you mean just Friday i.e. a single day as the weekend try this =SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{5},0)),1,0)) with your start date in a1 and end date in B1 This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array. Mike "Naushad" wrote: in a Workday function, Saturday & Sunday is taken as weekend. How can I make Friday as weekend instead of Sat & Sun |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Friday as weekend instead of Saturday & Sunday
oops,
Friday is 6 not 5 =SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{6},0)),1,0)) Mike "Mike H" wrote: Hi, If you mean just Friday i.e. a single day as the weekend try this =SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{5},0)),1,0)) with your start date in a1 and end date in B1 This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array. Mike "Naushad" wrote: in a Workday function, Saturday & Sunday is taken as weekend. How can I make Friday as weekend instead of Sat & Sun |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Friday as weekend instead of Saturday & Sunday
Hi,
What you have said it functions, but I want to find the end date if Start date and number of days is given (with Friday only as weekend). Suppose Thursday is the start date and number of days is 4 then End date should be Monday (i.e. thu, Sat, Sun & Mon) "Mike H" wrote: Hi, If you mean just Friday i.e. a single day as the weekend try this =SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(A1&":"& B1))),{5},0)),1,0)) with your start date in a1 and end date in B1 This is an array formula which must be entered with CTRL+Shift+Enter and NOT 'just enter. If you do it correctly then Excel will put curly brackets around 'the formula{}. You can't type these yourself. If you Edit the ranges 'then you must re-enter as An array. Mike "Naushad" wrote: in a Workday function, Saturday & Sunday is taken as weekend. How can I make Friday as weekend instead of Sat & Sun |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set NETWORKDAYS to regard friday and saturday as weekend | Excel Worksheet Functions | |||
| I want to set weekly off as Thursday instead of Saturday & Sunday | Excel Worksheet Functions | |||
| NETWORKDAYS including Saturday and Sunday | Excel Discussion (Misc queries) | |||
| Sunday to Saturday weekly foreward planner | Excel Worksheet Functions | |||
| Is there a way to identify saturday and sunday automatically | Excel Discussion (Misc queries) | |||
Linear Mode
