microsoft.com Home  
Microsoft
http://www.microsoft.com/office/ork  
Meeting the Year 2000 Challenge

Date Arguments in Microsoft Excel Functions

The date algorithm in Microsoft Excel 2000 and Excel 97 is different from the date algorithm in earlier versions of Excel.

The following Excel functions accept dates as arguments:

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

DATEVALUE

DAY

DAYS360

DISC

DURATION

EDATE

EOMONTH

INTRATE

MDURATION

MONTH

NETWORKDAYS

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

PRICE

PRICEDISC

PRICEMAT

RECEIVED

TBILLEQ

TBILLPRICE

TBILLYIELD

WEEKDAY

WEEKNUM

WORKDAY

XIRR

XNPV

YEAR

YEARFRAC

YIELD

YIELDDISC

YIELDMAT



Topic Contents   |   Previous   |   Top

Friday, March 5, 1999
© 1999 Microsoft Corporation. All rights reserved. Terms of use.

License