Back Up Next


Excel 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

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

  1. OfDate = date you want the fraction of
  2. 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.


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.