How to Use Dates in Excel

Add to Favorites
Author: | Edits: don

Introduction Guide to using Dates in Excel - this tutorial will show you how to input and use dates in Excel, including formatting and adding / subtracting days, months, and years from a date, and using the Excel serial number date format.

This Excel Date tutorial is for people who are trying to learn how dates work in Excel and it approaches this topic from the perspective of a complete beginner.

Oddly enough, dates can be quite complex in Excel, but this tutorial will provide you with a foundation that you can use to perform most of the date based calculations and input that you need to do and it also serves as a jumping-off point for more complex date based calculations in Excel.

Here is a list of the 10 topics covered in this tutorial:

  • Inputting dates correctly in Excel.
  • Formatting dates so they appear as you want, including showing the day of week, month, day, and year.
  • Working with date based serial numbers (how Excel sees dates).
  • How to enter dates as text.
  • How to get the day, month, or year from a date.
  • How to make a date using a dynamic formula and date function.
  • How to add and subtract days from a date.
  • How to add and subtract months from a date.
  • How to add and subtract years from a date.
  • How to add and subtract days, months, and years from a date at the same time.

This list of topics will provide you with a strong foundation for using dates in Excel.


Excel Function: DATE(), DAY(), EDATE(), MONTH(), YEAR()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Compare Values in Excel - Beginner to Advanced
Tutorial: How to compare text, numbers, and dates in Excel - including case sensitive text comparis...
Dates in Excel Explained
Tutorial: I'll explain how dates in Excel work and then point you to many useful tutorials on how t...
PI() Function in Excel - Math not Food
Tutorial: How to use the PI() function in Excel for math calculations - it's a pretty cool little f...
Using Parentheses in Excel
Tutorial: How to use parentheses in Excel in order to create more powerful formulas and functions. S...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refe...
Easy Way to Manage Names in Excel
Tutorial: How to manage Names in Excel so they are easy to view and change as needed. This is a li...
Tutorial Details
Excel Function: DATE(), DAY(), EDATE(), MONTH(), YEAR()
Downloadable Files: Excel File
Similar Content
Compare Values in Excel - Beginner to Advanced
Tutorial: How to compare text, numbers, and dates in Excel - including case sensitive text comparis...
Dates in Excel Explained
Tutorial: I'll explain how dates in Excel work and then point you to many useful tutorials on how t...
PI() Function in Excel - Math not Food
Tutorial: How to use the PI() function in Excel for math calculations - it's a pretty cool little f...
Excel Forum