YEARFRAC

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

Syntax

YEARFRAC(start_date, end_date, [basis])

This function has these arguments:

Argument	Description
start_date	[Required] Starting date (DateTime object)
end_date	[Required] Ending date (DateTime object)
basis	[Optional] Integer representing the basis for day count

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

YEARFRAC(A1,A2,A3)