A | B | C | Yearfrac formula | output |
11/10/2012 | 12/30/2015 | Yearfrac(A,C,1) | 3.1348391513 | |
11/10/2012 | 11/10/2015 | 12/30/2015 | Yearfrac(A,B,1)+Yearfrac(B,C,1) | 3.1349329133 |
<tbody>
</tbody>
the date is in mm/dd/yyyy format
Anyone know why the outputs is different?
it happen when there is leap year. If column A are year 2013, the output for row 1 & 2 is the same.