Excel Yearfrac Finds Fractions Of A Year Between Dates
Other Excel functions can find the number of days between two dates, but they are limited to returning a value in years, months, days, or a combination of the three. YEARFRAC, on the other hand, returns the difference between the two dates in decimal form automatically, such as 1.65 years, so that the result can be used directly in other calculations. These calculations could include values such as an employee’s length of service or the percentage to be paid for yearly programs that are terminated early such as health benefits....