Re: [office-formula] Reformulation of Day Count Bases

["Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>]

On Wed, 2010-09-22 at 16:30 -0600, robert_weir@us.ibm.com wrote:
> http://www.oasis-open.org/committees/download.php/39507/YEARFRAC.odt
> 

Just some observations:

In Procedure A:
- steps 2 and 3 should probably be switched
- step 4 is not needed since steps 5 and 6 will do that      

In Procedure C:
- steps 2 and 3 should probably be switched

In Procedure E:
- in step 6, "average number of days of the years between date1 and
date2" sounds complicated since there are only 2 years involved. Do you
mean "the average number of days in years year(date1) and year(date2)"?

On second thought procedure E is strange:
the days in year for date1=2001/1/1 and date2=2007/12/31 according to
that procedure is 366. Do we really want that? (I had thought that
actual/actual was reasonable).

Andreas


-- 
Andreas J. Guelzow
Concordia University College of Alberta