From the course: Excel Essential Training (Microsoft 365)
Join today to access over 24,700 courses taught by industry experts.
Working with dates and times in Excel - Microsoft Excel Tutorial
From the course: Excel Essential Training (Microsoft 365)
Working with dates and times in Excel
Excel is a great deal of computational capability when you work with dates and times, and provided you put in those dates in what we call a standard way. The regional settings in your version of Excel also come into play in terms of the format that you use. I'm using settings that are common in the United States, so when I type a date, I'll put in month, day, year. Typically in the United States, if I were putting in today's date at the time of this recording. It's in January of 2025. 1 slash 24 slash 25. I can either type a one digit or two digit year. I press enter and I see the information being displayed this way. I could have typed it with a dash as well. 1 dash 25 slash 25 the next day. This time I'll type a four digit year. Not truly necessary, but Excel sees that any time it does see information containing either dashes or slashes, it evaluates them potentially as dates, and if they are dates, they get stored in the right side of the cell. And that might sound like a trivial…
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.
