From the course: Excel 2016 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

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Working with dates and times

“

- Excel has a great deal of computational capability when it comes to working with dates. Also a number of built in functions that allow you to work with dates efficiently. If you're typing a data entry in Excel use / or - as the separator. Now in the United States, typically we display month, day, year, and that's the way we type it. In other countries it could be day/month/year. To type an entry like this, and I'll just type another one here. And so B 5 a different date. November 11/17/ and if it's 2016 I'll type a 16. Enter. I can also type a -. Same effect, January third, 2016. Type it this way, press enter. Any time you type entries using slashes or dashes Excel evaluates that entry with the possibility that it could be a date. And if it is, it displays it this way. And by the way, if you try an impossible date, how about 11/31, there are not 31 days in November, 15 enter, Excel displays this on the left side. Now it doesn't scream out at you and say error but it certainly looks…

Contents