Date and Time Functions - Excel - Microsoft Office Online

Click here to switch to other Office Online sites worldwide

Australia (change) | All Microsoft Sites

	Microsoft Office Excel

Search

	Try the 2007 release Buy the 2007 release
2007 Office system - try and buy

	Get personalised Office help in a newsletter
Discover, learn and share

	Check for updates
Office downloads

Microsoft Office Excel

» Excel Home

Product Information

» Overview

» Top 10 Benefits

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Excel 2007 Help

» Excel 2003 Help

» Excel 2002 Help

» Excel 2000 Help

Choose your version

» Excel Web Access

Training

» Excel 2007 Training

» Excel 2003 Training

» Excel 2007 Demos

» Excel 2003 Demos

Templates

» Templates for Excel

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Developer Center

» Office Resource Kit

Additional Resources

» Office Marketplace

» Discussion Groups

Home > Products > Excel > Excel 2003 Help and How-to > Working with Data > Function Reference

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.

Date and Time Functions

Documents 1-21 of 21

Page: [1] Go to previous page (disabled)

Date and time functions

DATE

DATEVALUE

DAY

DAYS360

EDATE

EOMONTH

HOUR

MINUTE

MONTH

NETWORKDAYS

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WORKDAY

YEAR

YEARFRAC

Documents 1-21 of 21

Page: [1] Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office Developer Center
» Office Community

» Office for Mac

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