YEARFRAC(S, E [, B])

 

Description

This function returns the year fraction representing the number of whole days between S (start date) and E (end date).  This function is useful in calculating the percent of benefit or obligation to assign a specific period.

 

Parameters

 

S

A datetime value that represents the start date.

 

E

A datetime value that represents the end date.

 

B

(Optional)  The day count basis to be used:

 

 

Examples

 

YEARFRAC(DATE(94, 1, 1), DATE(94, 5, 30), 0) = 0.4167

 

YEARFRAC(DATE(94, 1, 1), DATE(94, 5, 30), 1) = 0.4110