From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Understanding Excel date and time capabilities in formulas

Understanding Excel date and time capabilities in formulas

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Understanding Excel date and time capabilities in formulas

“

- In Excel, you can work with dates and times in a mathematical way. The underlying concept is based on the idea that every date has a value, starting January 1st 1900. It's unlikely you'd ever use that date in a formula or a function. But if you were to type 1 slash 1 slash 1900 and press Enter, you have actually entered the value of one. If you weren't sure, you can click the comma button. Now, how often do you really need to see that date number? Rarely. I'll undo that. Here's a date in 2015. What's the number for that? Here's a comma. That's what it is. But it does ultimately explain how we can work with dates in a mathematical way. For example, a starting date here in 2008 and ending date, this could apply to a person's 10 year in an organization. It could refer to a piece of equipment. How many days have elapsed between these two dates? Equal a later date minus an earlier date. How many days have elapsed? 2686. We can also work in a similar way with times over to the right in…

Contents