Excel 2016: Working with Dates and Times

- [Dennis] Hi, I'm Dennis Taylor, and welcome to this course on using dates and times in Excel. Whether you're using Excel to track order and shipping dates, calculating the age of your inventory, or tabulating hours worked on a project, you need to understand how Excel stores date and time data. I'll show you the best ways to enter dates and times, how to quickly build date/time series, and how to create your own custom date formats for optimum readability. We'll see powerful date functions that determine the day of the week, calculate working days between two dates, and determine future and past target dates.

We'll also look at shortcuts and tips to optimize tricky time calculations, the best techniques for converting dates downloaded from other sources, how to use dates with data validation rules, and use date filtering techniques as well. So, let's get started.