3.2 Exact Time
If the two dates that determine the interest period are known, it is important to calculate the exact number of days between those two dates. To do this, we count the beginning day but not the ending day of the period. We will always use a 365 day year, essentially ignoring leap year.
Example 3.2.1
Be sure to satisfy yourself that this simple subtraction of dates actually includes the first date but not the last.
You should also know that April, June, September and November have 30 days, February has 28 days (29 days during a leap year) and the remaining months have 31 days. Leap years occur every four years and are determined by getting an integer (a whole number) answer when dividing the last two digits of the year by four.
Example 3.2.2
How many days between April 16 and August 12?
Start Date: April 16 (counted)
End Date: August 12 (not counted)
Number of days:
April | = | (30 – 15) | = | 15 |
May | = | = | 31 | |
June | = | = | 30 | |
July | = | = | 31 | |
August | = | (12-1) | = | 11 |
TOTAL | = | = | 118 days |
Therefore,
[latex]t = \frac{118}{365}\;days[/latex]
Some calculators and computer software will calculate the days for the user. In this text we present two methods of date counting: using your calculator, and using a table. We also highly encourage students to take the time to learn how to use the date functionality in Microsoft Excel, as it is well worth the effort.
Using the BA II Plus to Find Exact Dates
We will use Question 16 from the Practice Problems to illustrate the exact date feature of the BA II plus calculator.
Example 3.2.3
- First, find the number of days between the debt and the focal date.
2nd Date | DTl = | 1.3002 Enter | Enter the date of the loan (month.day year) |
DT2= | 6.3002 Enter | Enter the focal date | |
DBD= | CPT | 151 from debt to focal date |
- Next, find the number of days from the $5,000 payment to the focal date.
2nd Date | DTl = | 3.0902 Enter | Enter the date of the first payment |
DT2= | 6.3002 Enter | This is the focal date – you do not need to re-enter | |
DBD= | CPT | 113 days from the payment to the focal date |
- Find the number of days from the second payment to the focal date.
2nd Date | DTl = | 5.2502 Enter | Enter the date of the second payment |
DT2= | 6.300 Enter | This is the focal date – you do not need to re-enter | |
DBD= | CPT | 36 days from the payment to the focal date |
We will finish solving this problem later on.
Dates using a Table
If you prefer to use tables, you can use the following:
Day of Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
1 | 1 | 32 | 60 | 91 | 121 | 152 | 182 | 213 | 244 | 274 | 305 | 335 |
2 | 2 | 33 | 61 | 92 | 122 | 153 | 183 | 214 | 245 | 275 | 306 | 336 |
3 | 3 | 34 | 62 | 93 | 123 | 154 | 184 | 215 | 246 | 276 | 307 | 337 |
4 | 4 | 35 | 63 | 94 | 124 | 155 | 185 | 216 | 247 | 277 | 308 | 338 |
5 | 5 | 36 | 64 | 95 | 125 | 156 | 186 | 217 | 248 | 278 | 309 | 339 |
6 | 6 | 37 | 65 | 96 | 126 | 157 | 187 | 218 | 249 | 279 | 310 | 340 |
7 | 7 | 38 | 66 | 97 | 127 | 158 | 188 | 219 | 250 | 280 | 311 | 341 |
8 | 8 | 39 | 67 | 98 | 128 | 159 | 189 | 220 | 251 | 281 | 312 | 342 |
9 | 9 | 40 | 68 | 99 | 129 | 160 | 190 | 221 | 252 | 282 | 313 | 343 |
10 | 10 | 41 | 69 | 100 | 130 | 161 | 191 | 222 | 253 | 283 | 314 | 344 |
11 | 11 | 42 | 70 | 101 | 131 | 162 | 192 | 223 | 254 | 284 | 315 | 345 |
12 | 12 | 43 | 71 | 102 | 132 | 163 | 193 | 224 | 255 | 285 | 316 | 346 |
13 | 13 | 44 | 72 | 103 | 133 | 164 | 194 | 225 | 256 | 286 | 317 | 347 |
14 | 14 | 45 | 73 | 104 | 134 | 165 | 195 | 226 | 257 | 287 | 318 | 348 |
15 | 15 | 46 | 74 | 105 | 135 | 166 | 196 | 227 | 258 | 288 | 319 | 349 |
16 | 16 | 47 | 75 | 106 | 136 | 167 | 197 | 228 | 259 | 289 | 320 | 350 |
17 | 17 | 48 | 76 | 107 | 137 | 168 | 198 | 229 | 260 | 290 | 321 | 351 |
18 | 18 | 49 | 77 | 108 | 138 | 169 | 199 | 230 | 261 | 291 | 322 | 352 |
19 | 19 | 50 | 78 | 109 | 139 | 170 | 200 | 231 | 262 | 292 | 323 | 353 |
20 | 20 | 51 | 79 | 110 | 140 | 171 | 201 | 232 | 263 | 293 | 324 | 354 |
21 | 21 | 52 | 80 | 111 | 141 | 172 | 202 | 233 | 264 | 294 | 325 | 355 |
22 | 22 | 53 | 81 | 112 | 142 | 173 | 203 | 234 | 265 | 295 | 326 | 356 |
23 | 23 | 54 | 82 | 113 | 143 | 174 | 204 | 235 | 266 | 296 | 327 | 357 |
24 | 24 | 55 | 83 | 114 | 144 | 175 | 205 | 236 | 267 | 297 | 328 | 358 |
25 | 25 | 56 | 84 | 115 | 145 | 176 | 206 | 237 | 268 | 298 | 329 | 359 |
26 | 26 | 57 | 85 | 116 | 146 | 177 | 207 | 238 | 269 | 299 | 330 | 360 |
27 | 27 | 58 | 86 | 117 | 147 | 178 | 208 | 239 | 270 | 300 | 331 | 361 |
28 | 28 | 59 | 87 | 118 | 148 | 179 | 209 | 240 | 271 | 301 | 332 | 362 |
29 | 29 | 88 | 119 | 149 | 180 | 210 | 241 | 272 | 302 | 333 | 363 | |
30 | 30 | 89 | 120 | 150 | 181 | 211 | 242 | 273 | 303 | 334 | 364 | |
31 | 31 | 90 | 151 | 212 | 243 | 304 | 365 |
Table 3-1: Days of the Year
Note carefully: For leap years (those years where the last two digits are divisible by four with an integer result), February 29 must be included and becomes day 60. One day must then be added to all dates following. (Examples of leap years: 2016, 2020, 2024, 2028, 2032 )
There are two occasions when extra care must be taken when using Table 3-1:
Leap Year
In a leap year, if the time period includes the end of February, every date after February 28 increases its count by one.
Be careful when your calculations include a leap year or a period that covers the end of a year.
Write the day count on a diagram.
Example 3.2.4
How many days between January 15 and May 28, 2024? (2024 is a leap year.)
January 15 is the 15th day of the year from Table 3-1.
May 28 is the 148th day of the year from Table 3-1. However, since the time period includes February 29, you must add one day to the value shown in the table.
Therefore, the exact number of days = (148 + 1) − 15 = 134.
When the Time Period Includes the End of the Year
Example 3.2.5
How many days between October 15, 2021 and February 13, 2022? The technique is to subtract the first day value from 365 (to get to the end of the year) and then to add the second day value to that difference (which moves you into a second year).
October 15 is the 288th day of the year from Table 3-1. Therefore, the number of days to the end of the year is (365 – 288) or 77.
February 13 is the 44th day of the year from Table 3-1. Therefore, the exact number of days is 77 + 44 = 121. You can draw a time line with the exact dates shown. To assist in calculating the exact time, get into the habit of also writing the day count on the diagram.
This will automatically lead you to an exact count of the number of days between any two dates. To illustrate this, note:
178 – 44 = 134 days between the first two dates,
288 – 178 = 110 days between the second two dates, and
288 – 44 = 244 days between the first and last dates.
Your Own Notes
- Are there any notes you want to take from this section? Is there anything you’d like to copy and paste below?
- These notes are for you only (they will not be stored anywhere)
- Make sure to download them at the end to use as a reference