YEARFRAC & Leap Years

Re: Yearfrac Calculation

Hi,

I don't think the fact that

Quote

the "leap" has yet to come!

matters. Your range in case 1) covers 3 different years, 1 of which is a leap year therefore the average days per year = 365.33333. This I think

Quote

is the "Actuality" of the divisor

Regards,

Eric

Re: Yearfrac Calculation

I'm not even sure it is really valid to use dates in two years, although they are allowed. The Help page only gives an example to get the fraction that a period is of a year, to give a pro-rata benefit.

Re: Yearfrac Calculation

yearfrac - Fraction of year between dates
Syntax
YearFraction = yearfrac(StartDate, EndDate, Basis)

Not sure about leapyear, it has always been a pain I reCall and something jiuk avoids. I have given the systax so You can check Your spot on just in case

jiuk[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Also see ----
Description

YearFraction = yearfrac(StartDate, EndDate, Basis) returns a fraction based on the number of days between dates StartDate and EndDate using the given day-count basis. If EndDate is earlier than StartDate, Fraction is negative.
Examples

YearFraction = yearfrac('14 mar 01', '14 sep 01', 0)

YearFraction =

0.5041

YearFraction = yearfrac('14 mar 01', '14 sep 01', 1)

YearFraction =

0.5000

See Also

days360, days365, daysact, daysdif, months, wrkdydif, year, yeardays

NOTE __ Credit to the author of this information jiuk has nabbed it, be happy to edit the post on evidence of Your work, sorry buddy I cant remember its old stuff I have saved <shrug> As always full credit where due