YEARFRAC

This function returns the fraction of the year represented by the number of whole days between the start and end dates.

YEARFRAC(startdate,enddate,basis)

This function has these arguments:

Argument	Description
startdate	Starting date (DateTime object)
enddate	Ending date (DateTime object)
basis	[Optional] Integer representing the basis for day count (Refer to Day Count Basis.)

This functions returns an error when start, end, or basis is invalid.

Accepts numeric, string, DateTime object data for the date arguments and numeric data for the optional argument. Returns numeric data.

YEARFRAC(A1,A2,A3)

This function is available in product version 2.0 or later.