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

Article translations Article translations
Article ID: 247795 - View products that this article applies to.
This article was previously published under Q247795
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

SYMPTOMS

In Microsoft Excel, certain financial functions may return an incorrect value.

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.

RESOLUTION

A Microsoft Excel 2000 Analysis ToolPak Update that resolves this issue is available for download from the following Microsoft Web site:
http://office.microsoft.com/downloads/2000/Atpy2k.aspx

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Properties

Article ID: 247795 - Last Review: October 22, 2013 - Revision: 3.4
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbdownload kbbug kbofficeupdate kbpending KB247795

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com