YEARFRAC
Returns the year fraction representing the number of whole days between start_date and end_date
Syntax
YEARFRAC(start_date, end_date, [basis])
Parameters
- start_date: Required. The start date
- end_date: Required. The end date
- basis: Optional. The type of day count basis to use (0=US 30/360, 1=Actual/actual, 2=Actual/360, 3=Actual/365, 4=European 30/360)
Example
=YEARFRAC("1/1/2024", "6/30/2024", 0)