Use the YEARFRAC function to calculate the fraction of a year between two dates (inclusive of the start date, exclusive of the end date).
The function uses a basis (day-count convention) to count the number of days between these dates, and then divide that number by the basis.
Syntax
YEARFRAC(Start, End[, Basis])
Arguments
| Argument | Data type | Description |
| Start (required) | Date | The bond settlement date: The date the bond is traded to the buyer. |
| End (required) | Date | The bond maturity date: The date when the bond expires. |
| Basis | Number | The basis determines how many days exist in a year. A full year has:
US 30/360 is the default basis for COUPDAYS. It can also be specified by entering 0. To use a different type of day count basis, enter:
Learn about the conventions used to calculate the day count for basis. |
The YEARFRAC function returns a number.
Financial functions are currently unavailable in Polaris. Learn more about the differences between Anaplan calculation engines.
Constraints
- The start and end dates must be valid dates between 01/01/1900 and 12/31/2399.
- The basis, when specified, must be either 0 (US (NASD) 30/360), 1 (Actual/Actual), 2 (Actual/360), 3 (Actual/365), or 4 (EUR 30/360).
Excel equivalent
Examples
This example shows a YEARFRAC calculation that includes a basis.
| Formula | Description | Result |
YEARFRAC(DATE(2015, 1, 15), DATE(2018, 4, 30), 1) | This formula uses:
| 3.28767123 |
This example shows a YEARFRAC calculation does not use a basis. As a result, the basis defaults to US 30/360.
| Formula | Description | Result |
| YEARFRAC(DATE(2015, 1, 15), DATE(2018, 4, 30)) | This formula uses:
| 3.29166666 |
