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.

Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.