| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting XL to Calc Working Days Lost without using NETWORKDAYS() Function
richarjb via OfficeKB.com Wrote: Thanks DLL Is that an array in there within the braces? daddylonglegs wrote: Here's another option which doesn't require Analysis ToolPak =SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7)) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200605/1 Yes it is - why do you ask? formula doesn't require CTRL+SHIFT+ENTER -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=543692 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Lost NETWORKDAYS functionality | Excel Worksheet Functions | |||
| how to use networkdays returning fractions of days (4.3 days) | Excel Worksheet Functions | |||
| MS Excel Function - Networkdays | Excel Worksheet Functions | |||
| Re-assigning weekend days in "Networkdays" Function | Excel Discussion (Misc queries) | |||
Threaded Mode
