YEARFRAC
Category: DateTime Function.
Description: Returns the year fraction representing the number of whole days between start_date and end_date.
Syntax: YEARFRAC(start_date, end_date, basis)
The basis is an optional parameter that specifies the type of day count. Basis values are listed in the following table.
|
Basis
|
Day count basis
|
|
0 or omitted
|
US (NASD) 30/360
|
|
1
|
Actual/actual
|
|
2
|
Actual/360
|
|
3
|
Actual/365
|
|
4
|
European 30/360
|