From the course: Excel: Advanced Formulas and Functions

YEARFRAC

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial

YEARFRAC

“

- [Instructor] Here is a function I want to show you. You might not use it much, but I'm showing it to you. Why? So that when you need something, you might go into Excel and see if it's there, rather than do you have to write some complex formula. If you poke around, if you ask some questions because wow, there are a lot of formulas here. Financial, text, we've got the engineering functions, so many functions and this one is going to help us because you have asked me to help you look at the careers of people that you used to manage. Yes, you manage this singer and for comedians and here we go. We don't need anything super precise. This is what we want. Equals YEARFRAC. Double click. Start_date. That singer's first show was 1st of November 2010. Comma, end_date, right? We're not going to get into the basis. That's an optional component of YEARFRAC. And it involves how do you want European dates handled, American dates, leap years, et cetera. We don't need that for what we're doing. Close parentheses and enter. So it's showing us two years for that singer. Let's go back here. Double click. All right, for the band that had its first show on the 1st of October, their career so far is 14.086 years. Okay, let's highlight this and adjust the decimal places. Okay, I'm going to decrease decimal places. Okay. That's what we want to look at. And this is the picture of the clients that you had. And notice the comedian lasted an entire 0.18 years. Probably wasn't very funny or just decided to move on with life. You know, bought a shrimp boat and is down on the Gulf near Louisiana, shrimping, living the life. No more stages and hecklers, and staying up to 2 o'clock in the morning. Left that life behind. But anyway, there is the YEARFRAC function.

Contents