| Financial Toolbox | ![]() |
Fraction of year between dates
Syntax
Arguments
Description
Fraction = yearfrac(StartDate, EndDate, Basis)
returns a fraction based on the number of days between dates StartDate and EndDate using the given day-count basis. If EndDate is earlier than StartDate, YearFraction is negative.
Examples
Fraction = yearfrac('14 mar 01', '14 sep 01', 0) Fraction = 0.5041 Fraction = yearfrac('14 mar 01', '14 sep 01', 1) Fraction = 0.5000
See Also
days360, days365, daysact, daysdif, months, wrkdydif, yeardays
| yeardays | ylddisc | ![]() |