next up previous contents index
Next: DB Up: A. Function Reference Previous: DAY   Contents   Index


DAYS360

Syntax: DAYS360(S, E)

S = Start date
E = End date

DAYS360 returns the number of days between two dates, based on a 30/360 Day Count Basis (30-day-per-month, 360-day year.) Please refer to ``Financial Functions'' in Chapter 4 for more detail on 30/360 day count basis.

Examples:

DAYS360(DATE(92, 5, 1), DATE(92, 6, 1)) = 30

DAYS360(DATE(93, 2, 28), DATE(93, 3, 1)) =1

DAYS360(DATE(92, 2, 28), DATE(923, 1)) = 3 (1992 is a leap year.)

Excel function: DAYS360


next up previous contents index
Next: DB Up: A. Function Reference Previous: DAY   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003