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

• Microsoft Excel 2000

SYMPTOMS

In Microsoft Excel 2000, 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 corrects this problem is available for download on the Office Update site:

http://officeupdate.microsoft.com/2000/downloadDetails/Atpy2k.htm

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 2000.

MORE INFORMATION

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/year2000/

Additional query words: XL2000 atp y2k year2000 year 2000

Keywords : kb2000 xlformula xladdins
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug