Dates in Excel Explained

Add to Favorites

I'll explain how dates in Excel work and then point you to many useful tutorials on how to use dates and also times in Excel.

What is a Date in Excel?

Dates in Excel are actually just numbers that are formatted as dates.

If you take a date and select the cell and then set that cell's formatting to "General" it will look like this:

Cell A1 has the "date" and cell A2 has that same date formatted as "General."

As you can see, Excel stores dates in this weird format, but, it's actually not that weird and makes handling dates a lot easier.  Excel stores dates as numbers.

The dates actually start at January 1, 1900, which is represented with a 1, and add one for each day since then.  So Feb 10, 2016 is 42,409 days since January 1, 1900.

Look at what happens when you format 1 as a date (it appears as the date 1/1/1900):

Why Does this Matter?

The point to learning that dates are just numbers in Excel is because, then, you can more easily remember how to manage them.

Add a day to a date by adding 1. Add a week by adding 7.

Cells A4 and A5 show the formulas entered in cells B4 and B5.

As you can see, storing dates as numbers makes dates easier to work with because we can use simple math to adjust them.

Helpful Date Tutorials

This is just an intro to help you wrap your head around the concept of dates in Excel.  There are many more complex things that you can do with dates and also with times in Excel.

Here is a link to all of our date and time tutorials: Date and Time Tutorials for Excel

Notes

There is a lot to learn about dates; make sure to check out the link above to see all of our tutorials on that subject.

Download the accompanying spreadsheet so you can see the examples from this tutorial in Excel.


Downloadable Files: Excel File

Similar Content on TeachExcel
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Get the Number of Workdays Between Two Dates in Excel
Tutorial: How to calculate the total number of working days between two dates in Excel.  This allows...
Vlookup on Dates and Times in Excel
Tutorial: Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of l...
Convert an Incorrect Date Format into a Real Date in Excel
Tutorial: Change an incorrectly formatted/input date into the proper date format for Excel. This tut...
Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY
Tutorial: How to find a date that is so many days before or after a specified date, excluding weeken...
Create Gantt Chart in Excel Easily
Tutorial: Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it sh...