YEARFRAC

Returns the ratio between days in specified interval to the number of days in a year.

Syntax

YEARFRAC( Date startDate, Date endDate, [Integer method] ) → Number

Parameters

startDate	Required. The start date of the interval.
endDate	Required. The end date of the interval.
method	Optional. 0 = U.S. (NASD) 30 / 360 number of days. 1 = actual / actual number of days. 2 = actual / 360. 2 = actual / 365. 4 = European 30/360.

Remarks

This formula lets you include in calculations the proportion of specified time interval relative to whole year.

See Also

Function Reference
DAYS Function
DATEDIF Function