
Type: Bug

Status: Applied

Priority: Major

Resolution: Fixed

Affects Version/s: ODF 1.2 Part 2 CD 1

Fix Version/s: ODF 1.2 CD 06

Component/s: OpenFormula

Labels:None

Proposal:
I thought we nailed this one a while ago, but I see the problem still in Part 2, CD 01.
YEARFRAC is currently defined as "Computes the fraction of the number of years between a StartDate and EndDate.
Basis is the system for determining how many days are in a month or year."
OK. So YEARFRAC is A/B where A= number of days between the two dates, using the counting conventions of the basis. And B is what? A year certainly. But how many days? 365? 365.25? Dependent on whether date 1 or date 2 is in a leap year?
I thought David figured this out at one point.