Date Arguments in Microsoft Excel Functions - Office 2000 Resource Kit

Click here to switch to other Office Online sites worldwide

United States (change) | All Microsoft Sites

	Office 2000 Resource Kit

Search

	Check for free updates
Office downloads

Office 2000 Resource Kit

» Office System on TechNet

» Desktop Applications TechCenter

Versions

» 2007 Office Resource Kit

» Office 2003 Resource Kit

» Office XP Resource Kit

» Office 2000 Resource Kit

» Office 97 Resource Kit

Table of Contents

Home > Help and How-to > Office System on TechNet > Office Resource Kit > Office 2000 Resource Kit > Upgrading to Office 2000 > Meeting the Year 2000 Challenge

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Date Arguments in Microsoft Excel Functions

Meeting the Year 2000 Challenge

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

Printer-Friendly Version

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office for Mac
» Office Community

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide