Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Networkdays Function Not Working
I have been successfully using this function for quite some time. My formula
is (=if(t30,networkdays(r3,u3)," ") where t3 is a date also. Before you ask, yes, I have the analysis tool pack add-in. The only difference is I have switched over to the new XP operating system. Any ideas? -- Al H. |
#2
|
|||
|
|||
First, what do you mean by "not working"? Do you get an error? An
incorrect result? Is your add-in installed in XL, as well as on your HD (e.g., Tools/Add-ins...) is r3 earlier than u3? In article , "Al H." wrote: I have been successfully using this function for quite some time. My formula is (=if(t30,networkdays(r3,u3)," ") where t3 is a date also. Before you ask, yes, I have the analysis tool pack add-in. The only difference is I have switched over to the new XP operating system. Any ideas? |
#3
|
|||
|
|||
I have a solution and the function is now working. The error was #NAME?.
The only thing in the formula bar that did not switch to UPPERCASE was the function "networkdays" telling me that "networkdays" function was the problem. Turns out the fix was my permissions on my new XP computer. Thank you for your willingness to help. "JE McGimpsey" wrote: First, what do you mean by "not working"? Do you get an error? An incorrect result? Is your add-in installed in XL, as well as on your HD (e.g., Tools/Add-ins...) is r3 earlier than u3? In article , "Al H." wrote: I have been successfully using this function for quite some time. My formula is (=if(t30,networkdays(r3,u3)," ") where t3 is a date also. Before you ask, yes, I have the analysis tool pack add-in. The only difference is I have switched over to the new XP operating system. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
How do I install the networkdays function! | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Function in xl2003 not working in xl97 | Excel Discussion (Misc queries) | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |