software

I'm a bit confused what the second parameter in ACCRINT does. Microsoft has
documented the calculation of ACCRINT at
office.microsoft.com/en-us/as...089791033.aspx but the
second parameter doesn't appear in the formula. Furthermore the calculation
of ACCRINT was changed somewhere between Excel 97 and Excel 2003:
support.microsoft.com/kb/904826/en-us

I use Excel 2003. Is the second parameter in ACCRINT now deprecated? It
doesn't seem to affect the calculation most of the time. However when you
enter some special dates you get weird results. Try for example
ACCRINT(quot;1/1/2000quot;, quot;2/28/2000quot;, quot;12/31/2000quot;, 0.01, 100, 1, 0) and
ACCRINT(quot;1/1/2000quot;, quot;2/29/2000quot;, quot;12/31/2000quot;, 0.01, 100, 1, 0) - they don't
return 1. Is this a known bug or is there something I don't understand about
ACCRINT?

Boris