From the course: Excel: Advanced Formulas and Functions
Join today to access over 23,100 courses taught by industry experts.
YEARFRAC
From the course: Excel: Advanced Formulas and Functions
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…
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.