XL2000: Some Financial Functions May Return Incorrect Results with February 29, 2000

Article ID: 247795 - View products that this article applies to.
This article was previously published under Q247795
Expand all | Collapse all

SYMPTOMS

In Microsoft Excel, certain financial functions may return an incorrect value.
Back to the top | Give Feedback

CAUSE

Excel may calculate an incorrect value when the following conditions are true:
  • You are using one of the following worksheet functions provided by the Analysis ToolPak add-in:

    • ACCRINT
    • COUPDAYBS
    • COUPDAYS
    • COUPDAYSNC
    • COUPPCD
    • COUPNCD
    • DURATION
    • MDURATION
    • ODDFPRICE
    • ODDFYIELD
    • PRICE
    • YIELD


    -and-

  • The bond's maturity, settlement, or first interest payment takes place on February 29, 2000.
Back to the top | Give Feedback

RESOLUTION

A Microsoft Excel 2000 Analysis ToolPak Update
(http://office.microsoft.com/downloads/2000/Atpy2k.aspx)
that resolves this issue is available for download from the following Microsoft Web site:
http://office.microsoft.com/downloads/2000/Atpy2k.aspx
(http://office.microsoft.com/downloads/2000/Atpy2k.aspx)
Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top | Give Feedback

Properties

Article ID: 247795 - Last Review: May 12, 2007 - Revision: 3.4
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbdownload kbbug kbofficeupdate kbpending KB247795
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top