| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating End Date - Given working 4, 5, 6, or 7 day workwee
John wrote:
Big help! Thanks!!!... Small correction/clarification-- I said SMALL returns the k (A3)'th member of the array, Actually SMALL returns the k'th smallest member of the array. Since the array of dates is in ascending order, this is functionally equivalent to the k'th member where FALSE values are ignored. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workweek | Excel Discussion (Misc queries) | |||
| WorkWeek | Excel Discussion (Misc queries) | |||
| Calculating three working days before a date | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| 4 Day Workweek | Excel Worksheet Functions | |||
Threaded Mode
