		microsoft.com Home

http://www.microsoft.com/office/ork

Microsoft Office 2000 Resource Kit Home

Upgrading to Office 2000

Planning Your Move to Office 2000


Before You Upgrade to Office 2000

Converting Files to Office 2000

New Tools for the Conversion Process

Meeting the Year 2000 Challenge

Office 2000 Upgrading Reference

Overview of Tools and Utilities

Glossary

Index

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