Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.

Aug 30, 2024 · This is the ultimate guide to all Excel's time and date functions. Learn how to add time, subtract dates, calculate date differences, and more.

Aug 26, 2025 · We use Excel’s date functions to handle dates and times effectively. By combining functions like TODAY and EOMONTH, we tackle complex scheduling and analysis.

Mar 21, 2023 · A comprehensive tutorial on using date functions in Excel explains the basics and provides formula examples of DATE, TODAY, NOW, DATEVALUE and lots of other functions.

May 4, 2022 · Whether you use Microsoft Excel for managing monthly bills or tracking time for work, you likely use dates or times. With these functions, you can enter or obtain the dates …

May 28, 2024 · 8 quick methods to enter date and time in Excel. Download the practice workbook and modify the data to find new results.

This page lists the built-in Excel Date and Time Functions. If you are not familiar with the way that Excel stores dates and times as numeric values, you may find it useful to read the Excel Dates …

Jun 5, 2025 · Master Excel time formulas to create, calculate, and format time values with confidence. Learn to solve issues like negative durations and time overflows.

Click each of the function link to see detailed example. Note: Excel stores dates as numbers.