Abstract
In this video, we show you how to enter dates so that they are recognized as dates by Excel.
Transcript
In this lesson, we'll look at how to enter dates in Excel.
To enter a date in Excel, you need to type the date in a format that Excel can recognize. When checking for a date, Excel will look for a month, a day, and a year in a variety of formats. If you don't supply a year, Excel will use the current year.
Let's take a look.
In North America, Excel defaults to a month, day, year format, so dates following this format are easily recognized.
Many other formats are supported as well.
If we leave out the year, Excel will assume we mean a date in the current year and add the year for us.
This is handy if you're doing data entry in the current year, but make sure you supply a year for any dates that are not in the current year.
