ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Function =DIAS.LAB(A1;A2) (https://www.excelbanter.com/excel-worksheet-functions/207064-function-%3Ddias-lab-a1%3Ba2.html)

Walter TC

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

ShaneDevenshire

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


Bob Phillips[_3_]

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




ShaneDevenshire

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






All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com