Appendix B: Reference Information 640
Days between Dates
Days between DatesDays between Dates
Days between Dates
With the dbd( function, you can enter or compute a date within the range Jan. 1, 1950,
through Dec. 31, 2049.
Actual/actual day-count method (assumes actual number of days per month and
actual number of days per year):
dbd( (days between dates) = Number of Days II - Number of Days I
4Nom =
where: x=.01 × Eff
Eff =effective rate
CP =compounding periods
Nom =nominal rate
Number of Days I = (Y1-YB) × 365
+ (number of days MB to M1)
+DT1
+
Number of Days II = (Y2-YB) × 365
100 CP [×× e1CP÷x1+()ln×1]–
Y1YB–()
4
------------------------