Hi. I would like to understand how the YeaFrac calculation (basis 1) is being computed. When I do YearFrac(StartDate, EndDate, 1) manually I am not coming up the same results and therefore would liek to understand how this is being c
The following describes the syntax for YEARFRAC() and provides an example:
For basis 1, the calculation is actual number of days in the month divided by actual number of days in the year.