Days or Years Between Two Dates
Last updated 9 November 2026
Function reference › Interest Rates › Time
1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].
GIA_IR_DaysOrYears
Returns the number of days or years (usually year fraction) between two dates, according to the most commonly used day-count methods.
GIA_IR_DaysOrYears(StartDate, EndDate, Days, OT)Returns: Number of days or years (usually year fraction) between two dates, according to the most commonly used day-count methods
| Argument | Use | Description |
|---|---|---|
StartDate | Required | The start date. |
EndDate | Required | The end date. |
Days | Required | The time basis of the interest rates (act/act, act/360, act/365, 30/360, 30E/360, 30US/360, 30G/360, 30I/360, NL-365) |
OT | Required | Output type (Days, Years) |