Filter
Top Products
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
4
Nom =
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 [×× e
1 CP÷ x 1+()ln×
1 ]–
Y1 YB–()
4
------------------------