[OASIS Issue Tracker] Commented: (OFFICE-2630) YEARFRAC ambiguity

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18359#action_18359 ] 

Eike Rathke commented on OFFICE-2630:
-------------------------------------

Yes, 3.11.6 Basis covers the number of days in a year, but that doesn't solve the leap year problem for Basis 1 (actual/actual) here.

I also remember we had some discussion about leap years in date calculation on the mailing list,but IIRC that was related to DAYS360 or DATEDIF, would have to dig out. DAYS360 does define the algorithm for leap years, DATEDIF does not (missed to add the result of the discussion?).


> YEARFRAC ambiguity
> ------------------
>
>                 Key: OFFICE-2630
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2630
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 1
>            Reporter: Robert Weir 
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira