Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function =DIAS.LAB(A1;A2)
Hi
I use Excel 2003 SP3 (version spanish), but I don't have the function =DIAS.LAB(A1;A2) Why? Thanks from Perú Walt |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function =DIAS.LAB(A1;A2)
Hi,
What does that function do? In the English version of Excel not such function exists, and there is only one function the has a period in the name. I suspect that this is part of an Add-in, and the add-in is not attached. Try Tools, Add-ins, and see if there is an add-in that rings a bell for you that is not checked. If so check it. -- Thanks, Shane Devenshire "Walter TC" wrote: Hi I use Excel 2003 SP3 (version spanish), but I don't have the function =DIAS.LAB(A1;A2) Why? Thanks from Perú Walt |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function =DIAS.LAB(A1;A2)
That is the NETWORKDAYS function, so you need to have the Analysis Toolpak
addin installed. -- __________________________________ HTH Bob "Walter TC" <Walter wrote in message ... Hi I use Excel 2003 SP3 (version spanish), but I don't have the function =DIAS.LAB(A1;A2) Why? Thanks from Perú Walt |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function =DIAS.LAB(A1;A2)
Hi Bob,
Are there lots of function in the Spanish version that take this unusual notation? Hi Walter, What Bob is saying is choose Tools, Add-ins, and put a check beside Analysis ToolPak. There are about 100 spreadsheet function in this add-in, many very useful in my opinion, but you do need to attach the add in to use them. Keep in mind, if you send the file to someone else they will get a NAME error message (I don't know what it is in Spanish) if they don't attach the add in also. In 2007 these functions are built into Excel but you still need to attach the add in if you want to use the Data Analysis command. -- Thanks, Shane Devenshire "Bob Phillips" wrote: That is the NETWORKDAYS function, so you need to have the Analysis Toolpak addin installed. -- __________________________________ HTH Bob "Walter TC" <Walter wrote in message ... Hi I use Excel 2003 SP3 (version spanish), but I don't have the function =DIAS.LAB(A1;A2) Why? Thanks from Perú Walt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
DIAS.LAB function poblem | Excel Worksheet Functions | |||
DIAS.LAB function problem | Excel Discussion (Misc queries) | |||
networkdays or dias.lab | Links and Linking in Excel |