| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS alternative, for use without Analysis ToolPak
I'm trying to build a formula to calculate the number of working days /
hours between 2 specified dates. This will be used in multiple workbooks, by various users, who may not have the ability to run code or install the Analysis toolpak. I've consulted http://www.cpearson.com/excel/DateTimeWS.htm and modified the formula accordingly - so far so good! But this still relies on the NETWORKDAYS function from the Analysis ToolPak. How can I rewrite this formula to avoid the networkdays function? -- Olly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS gives #NAME even though Analysis Toolpak is installed | Excel Worksheet Functions | |||
| How can I get the Analysis Toolpak | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
| Analysis Toolpak add in | Excel Worksheet Functions | |||
Threaded Mode
