Filter
Top Products
162 Appendix A: Tables and Reference Information
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
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
+ (number of days MB to M2)
+ DT2
+
where: M1
DT1
Y1
M2
DT2
Y2
MB
DB
YB
=
=
=
=
=
=
=
=
=
month of first date
day of first date
year of first date
month of second date
day of second date
year of second date
base month (January)
base day (1)
base year (first year after leap year)
Y1 YB–()
4
------------------------
Y2 YB–()
4
------------------------