YEARFRAC

Date/Time Functions:
Function: DAYS360() - Returns the number of days between two dates based on a 360-day year.
Between: 1900-01-01 and 2022-12-31
Days: 123 - US (NASD) 30/360
Days: 123 - Actual
Days: 124.79166666667 - Actual/360
Days: 123.08219178082 - Actual/365
Days: 122.99722222222 - European 30/360
Between: 1904-01-01 and 2022-12-31
Days: 119 - US (NASD) 30/360
Days: 118.99726216496 - Actual
Days: 120.73333333333 - Actual/360
Days: 119.07945205479 - Actual/365
Days: 118.99722222222 - European 30/360
Between: 1936-03-17 and 2022-12-31
Days: 86.788888888889 - US (NASD) 30/360
Days: 86.789187147937 - Actual
Days: 88.055555555556 - Actual/360
Days: 86.849315068493 - Actual/365
Days: 86.786111111111 - European 30/360
Between: 1960-12-19 and 2022-12-31
Days: 62.033333333333 - US (NASD) 30/360
Days: 62.030811351093 - Actual
Days: 62.936111111111 - Actual/360
Days: 62.07397260274 - Actual/365
Days: 62.030555555556 - European 30/360
Between: 1999-12-31 and 2022-12-31
Days: 23 - US (NASD) 30/360
Days: 23.000684462697 - Actual
Days: 23.336111111111 - Actual/360
Days: 23.016438356164 - Actual/365
Days: 23 - European 30/360
Between: 2000-01-01 and 2022-12-31
Days: 23 - US (NASD) 30/360
Days: 22.997262230687 - Actual
Days: 23.333333333333 - Actual/360
Days: 23.013698630137 - Actual/365
Days: 22.997222222222 - European 30/360
Between: 2019-02-14 and 2022-12-31
Days: 3.8805555555556 - US (NASD) 30/360
Days: 3.8767967145791 - Actual
Days: 3.9333333333333 - Actual/360
Days: 3.8794520547945 - Actual/365
Days: 3.8777777777778 - European 30/360
Between: 2020-07-04 and 2022-12-31
Days: 2.4916666666667 - US (NASD) 30/360
Days: 2.4908759124088 - Actual
Days: 2.5277777777778 - Actual/360
Days: 2.4931506849315 - Actual/365
Days: 2.4888888888889 - European 30/360
Between: 2020-02-29 and 2022-12-31
Days: 2.8333333333333 - US (NASD) 30/360
Days: 2.8357664233577 - Actual
Days: 2.8777777777778 - Actual/360
Days: 2.8383561643836 - Actual/365
Days: 2.8361111111111 - European 30/360
Between: 2029-12-31 and 2022-12-31
Days: 7 - US (NASD) 30/360
Days: 7.0006844626968 - Actual
Days: 7.1027777777778 - Actual/360
Days: 7.0054794520548 - Actual/365
Days: 7 - European 30/360
Between: 2525-01-01 and 2022-12-31
Days: 502.00277777778 - US (NASD) 30/360
Days: 502.00406340653 - Actual
Days: 509.31388888889 - Actual/360
Days: 502.33698630137 - Actual/365
Days: 502.00277777778 - European 30/360