From the course: Excel Essential Training (Microsoft 365)
Join today to access over 23,200 courses taught by industry experts.
Working with dates and times
From the course: Excel Essential Training (Microsoft 365)
Working with dates and times
- [Instructor] Many Excel worksheets deal with dates and/or times. Excel has great computational capability when it comes to using these, however, the date entries themselves must adhere to a couple of basic rules. I'm going to type in a date, May 6th, 5/6/22. If you type any entry with a slash or a dash, Excel evaluates that as if it could be a date. If it is a valid date, Excel displays the information as you typed it, but actually stores a value in the background. You don't need to know a whole lot about that, other than the fact that the entire date system starts January 1st, 1900. That's day one, the next day is day two and so on, and that allows us to work with dates in a computational way. If you type these with a dash, I'll do the same date again, 5-6-22, Excel understands that too and displays it with the slashes in the standard way. If you type a date that doesn't exist, like this one here, and even if you…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.