Yearfrac problem

I have Excel 2002 in spanish. I created a system that calculates the interest
service from varios kind of debt from a Company. It requires to use the
yearfrac function to calculate how many days between each payment are to be
taken into account for the calculation of interest, given the diversity in
the types of bonds that this company issued.

The system requires to open for example 3 BIG!!! workbooks at the same time
(stock, cupons and proyected service) stock and cupon feed proyected service,
so they are linked. The function yearfrac is used in the workbook "cupons".

I have activated the add-ins required to use yearfrac. However when I open
the 3 workbooks I find that every place where I used the function yearfrac in
the woorkbook cupons the system substituted it for another name using the
path of the program ATPVBAEN.XLA , and aditionally it introduced the latter
as an external link!!!!! which I did no create.

After that the workbook "cupons" give me the error #Value where it is
suppose to calculate yearfrac!!!!.

Could somebody please help me and tell me how to correct it and why it
happen!!!!!

Thanks a lot!!!

Adriana

Hi Adriana,

As far as I know, the functions included into the Microsoft Analysis
ToolPack are not authomatically translated accross different language
platforms. So you will either have to substitute the function name with its
Spanish version (FRAC.ANO) manually or create a formula, which uses standard
Excel functions. I guess, using the function DETEDIF (Spanish SIFECHA is a
bizarre translation :-)) could do the trick as, I think, it is
authomatically translated and even in Spanish version requires english
constants, e.g.
=SIFECHA(A1,B1,"Y")
where "Y" stands for Yearss instead of expected "A" - Ano. For more info,
see Excel help regarding this function (documented as from XL2000 version)

Hope this helps.

Saludos,
KL

"Adriana" <[email protected]> wrote in message
news:[email protected]...
>I have Excel 2002 in spanish. I created a system that calculates the
>interest
> service from varios kind of debt from a Company. It requires to use the
> yearfrac function to calculate how many days between each payment are to
> be
> taken into account for the calculation of interest, given the diversity in
> the types of bonds that this company issued.
>
> The system requires to open for example 3 BIG!!! workbooks at the same
> time
> (stock, cupons and proyected service) stock and cupon feed proyected
> service,
> so they are linked. The function yearfrac is used in the workbook
> "cupons".
>
> I have activated the add-ins required to use yearfrac. However when I open
> the 3 workbooks I find that every place where I used the function yearfrac
> in
> the woorkbook cupons the system substituted it for another name using the
> path of the program ATPVBAEN.XLA , and aditionally it introduced the
> latter
> as an external link!!!!! which I did no create.
>
> After that the workbook "cupons" give me the error #Value where it is
> suppose to calculate yearfrac!!!!.
>
> Could somebody please help me and tell me how to correct it and why it
> happen!!!!!
>
> Thanks a lot!!!
>
> Adriana