Measure Fractional Years

This component computes the fraction of the year of the difference between two dates, similar to the YEARFRAC function in Microsoft Excel.

The component outputs two columns:

- The "YEARFRAC" column contains the difference between the start date and the end date as a fraction, that is the number of whole days between the dates divided by the total days per year.

- The "Difference Value (in Months)" contains the same difference, but given in months.

Similarly to Microsoft Excel YEARFRAC function, the output measures depend on the “basis”, a parameter which controls how many days make a financial year.

Input ports

1. Type: Table
   Input Data
   A table with at least two Date&Time columns for the start and end date of time periods. Each row should describe a period in time for which fractional years can be measured.

Output ports

1. Type: Table
   Difference Data
   Input data table with additional two columns: the measured fractional years and the same time difference measured in months.