Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does the second parameter in ACCRINT do?
I'm a bit confused what the second parameter in ACCRINT does. Microsoft has
documented the calculation of ACCRINT at http://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: http://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("1/1/2000", "2/28/2000", "12/31/2000", 0.01, 100, 1, 0) and ACCRINT("1/1/2000", "2/29/2000", "12/31/2000", 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criteria using "Or" and parameter query | Excel Discussion (Misc queries) | |||
How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
How do i enable the Query Parameter menu option on the External D. | Excel Discussion (Misc queries) | |||
Wildcard parameter in excel | Excel Discussion (Misc queries) | |||
Changing a Parameter Of A Formula | Excel Worksheet Functions |