next up previous contents index
Next: YIELD Up: A Function Reference Previous: YEAR

YEARFRAC

 

Syntax: @YEARFRAC(S, E[, B])

S = a date value that represents the start date
E = a date value that represents the end date
B = (Optional) The day count basis to be used:

0 or omitted 30/360
1 Actual/actual
2 Actual/360
3 Actual/365

@YEARFRAC 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.

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


next up previous contents index
Next: YIELD Up: A Function Reference Previous: YEAR

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999