YEARFRAC function


DESCRIPTION:

Returns the year fraction.

 

SYNTAX:

=YEARFRAC( start_date, end_date, [basis] )

 

REQUIRED ARGUMENTS:

start_date

The start date.

end_date

The end date.

 

OPTIONAL ARGUMENTS:

[basis]

The type of day count basis to use.