Re: COUPDAYS Help needed



Andreas J. Guelzow wrote:-

For COUPDAYS: 

With base 2 Act/360, the Windows versions of XL return 360, 180 or 90 
depending on frequency. The Mac version I have essentailly counts real 
days.

Similarly, with base 3 Act/365, the Windows versions of XL return 365, 
182.5 or 91.25 depending on frequency. The Mac version I have 
essentailly counts real days.

Wow.  My awe of MS's obviously combined codebases grows each day.  How
you can have two code bases for a plug-in that is obviously
OS-independent I don't know.

We have a choice, then, and clearly we should pick the right one,
which in this case appears to be Windows.

Neil.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]