Description Computes the fraction of a year between two specified dates.
Syntax YEARFRAC ( start_date, end_date [, calendar_type] )
Argument | Description |
---|---|
start_date | The starting date. Dates in the argument list must be in the form of a serial number or text. |
end_date | The ending date. Dates in the argument list must be in the form of a serial number or text. |
[calendar_type] | Optional. One of five methods of counting days for computing interest. See The calendar_type Argument for more information. |
Remarks This function truncates all arguments to integers.
Examples This function returns 0.344:
YEARFRAC("1/11/97","5/15/97")
This function returns 1.344:
YEARFRAC("1/11/97","5/15/98")
See Also DAYS360