YEARFRAC Function

Originally published at: How to use the YEARFRAC Function in Excel - Excelbuddy.com

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The start date.end_date – The end date.basis – [optional] The type of day count basis to use (see image below). YEARFRAC Function Example As mentioned above, Excel calculates a decimal number…