From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Working with dates and times

Working with dates and times - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Working with dates and times

“

In this worksheet called "Dates-Times" in the 02-Entering Data Workbook, we've got a date entry in column B and some time entries in column D. Excel is adept at handling date and time information. You want to start off by just making sure that when you do put dates into Excel that you want to enter them in just a few different ways. First of all, if you're working in the United States with Excel, your standard Excel settings are to display dates as from left to right, month/day/year. In other countries it's likely to be day/ month/year, but this represents January 8, 2013. It's typed with slashes. The standard way of entering dates in Excel is with slashes or hyphens. No matter how you type it, you will see the display as slashes. So if we want to put in for example, November 17, 11/17 and it's in the same year, we'll type 13, Enter, no great surprises there. Same thing would happen of course if we type hyphens. It will display with the slashes. A small tip here, any date in the first…

Contents