Frac Add-in

frac.xla is an Excel '97 add-in containing a function called Frac() that calculates the fraction of the year. Download the zipped file AddIns.zip.

The function has two arguments =Frac( OfDate , [Places] )

OfDate = date you want the fraction of
Places = optional, number of places to round to

The Frac function is the 365 day calendar of decimals the every actuary uses. Each month equals 1/12th of the year. Then each day in that month is 1/(no of days in month) of the 1/12th.

Examples

	Frac(1/1/1985) = 1985.000
	Frac(2/16/1996) = 1996.126
	Frac(2/16/1997) = 1997.128
	Frac(7/1/1999) = 1999.500

Notice that the function takes into account leap years.

The program has been checked against other programs, but you are encouraged to check it yourself before relying on it. It is complimentary from us, Dean & Company, to anyone interested.

If you have questions or comments, please contact us at Dean & Company.