EXCEL.MAC CANT COUNT DAYS WITH BASE 360 DAY CALENDAR

[Carlos Julian Ruiz]

To count day with base 360 day calendar in a regular PC excell uses the
function days360(initialday;finnal day;method), in excel.mac the function is
D360() but it does not work, it only point to the d360 cell and does not do
the calculation.

This function is very importante for people who manage financial
calculations, What can we use then????

 

[Bernard Rey]

Carlos Julian Ruiz:

To count day with base 360 day calendar in a regular PC excell uses the
function days360(initialday;finnal day;method), in excel.mac the function is
D360() but it does not work, it only point to the d360 cell and does not do
the calculation.

In Excel 2004, the functions

=DAYS360(36891,37255)
=DAYS360("01/01/2005","12/31/2005")
=DAYS360(A1,B1)
all return the expected result, as far as I can see. Which version are you
running and how do you proceed?

 

[carlosruiz]

I use excel V 11.1(040909)
the lenguage is spanish.
the function list show that I should use D360()

I have tried:

=DAYS360(36891;37255) #¿NOMBRE? (SEPARATED BY ; )
=DAYS360(36891,37255) Error en la formula (SEPARATED BY , )
=DIAS360(36891;37255) #¿NOMBRE?
=DIAS360(36891,37255) Error en la formula
=D360(36891;37255) #¡REF!
=D360(36891,37255) Error en la formula

All of them did not work. The excell does normal sustraction as B1-B2
when B1 AND B2 are dates, but not the 360 calendar function.

Shoul I try any change on settings?

 

[Bernard Rey]

Well, I'm sorry, I can't say more about a Spanish version. I can only tell
it works as described in the English and the French version. The problem you
encounter may be limited to the Spanish version...

Maybe someone around using a Spanish version could say more?


carlosruiz: