From the course: Excel Essential Training (Microsoft 365)
Join today to access over 25,000 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
- [Instructor] Excel has 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/24/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've typed it with a dash as well, 1-25/25, the next day. This time I'll type a four-digit year. Not truly necessary. But Excel sees that, anytime 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 thing…
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.
