If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Networkdays calculations
Everytime I enter the formula, =networkdays(l5,k5) to
calculate how many days an employee will receive his/her new rate of pay for the new fiscal year, it brings back this error; NAME? |
#2
|
|||
|
|||
Networkdays calculations
NETWORKDAYS() is a function in the Analysis Toolpak Add-in. Choose
Tools/Add-ins and check the appropriate checkbox. FWIW- this is well documented in the NETWORKDAYS page in XL Help. In article , "Linda" wrote: Everytime I enter the formula, =networkdays(l5,k5) to calculate how many days an employee will receive his/her new rate of pay for the new fiscal year, it brings back this error; NAME? |
#3
|
|||
|
|||
Networkdays calculations
Linda,
The NETWORKDAYS function is part of the Analysis Tool Pack add-in, so you must have this add-in loaded to use the function. Go to the Tools menu, choose Add-Ins, and put a check next to "Analysis Tool Pak". -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Linda" wrote in message ... Everytime I enter the formula, =networkdays(l5,k5) to calculate how many days an employee will receive his/her new rate of pay for the new fiscal year, it brings back this error; NAME? |
Thread Tools | |
Display Modes | |
|
|