Date & Time Functions
This page lists the current, built-in Excel Date and Time Functions, which will assist you when working with Excel dates and times.
Before using Excel Date and Time Functions, it will help if you have an understanding of the way dates and times are stored in Excel - this is explained in the Excel Dates and Times page.
The functions listed below have been grouped into categories, to help you to find the function you need. Note that some of the functions are new to Excel 2010 or Excel 2013, so are not available in earlier versions of Excel. If you select a function name, this will take you to a full description of the function, with examples of use and common errors.