From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

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

Tabulating date differences with the DATEDIF function

Tabulating date differences with the DATEDIF function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Tabulating date differences with the DATEDIF function

“

- Excel has a valuable date-calculating function called datediff. But there's something odd about it. If you go to the formulas tab in the ribbon and go to the Date & Time functions, you do not see datediff and yet it works. If you're using Excel for the Mac, Excel version 2011 and prior for the Mac, you will see this with documentation. Here we don't see it and yet it's available and we can use it. =datediff. We're trying to calculate how many days have elapsed between a starting date and an ending date. This could refer to someone's work tenure. It could refer to a piece of hardware. Any number of different things. We've got a starting date here, cell A2, and ending date in B2. And we might want to know how many days have elapsed. "d" This is one of six variations. We see them over in column E. For the moment showing only days. 1088 days, we can see this for other days as well too. At other times, we might want to know how many years have elapsed. Now, in this case, it does the…

Contents