| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Include Saturday in the WORKDAY function
How do I include Saturdays to be counted in the WORKDAY function?
Assuming A1 is the start date, A2 is the duration, and B5:B10 is the holiday range, what should I put as the formula so that in A3, the end date would be calculated to give me the WORKDAY function, but including the Saturdays? currently, if i use the workday function in =IF(WEEKDAY(WORKDAY(A1,A2,B5:B10)-1,1)=1,WORKDAY(A1,A2,B5:B10)-3,WORKDAY(A1,A2,B5:B10)-1) it would give me the end date of the program after measuring the duration from the start date, (start date inclusive). However, I need to have it include saturdays. is there another way? or should I modify this formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| How do I get the WORKDAY function? | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Threaded Mode
