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

If the interest period ranges from May 12 to May 27,
 [latex]t = \frac{27 - 12}{365} =\frac{15}{365}\; years[/latex]

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

AW borrowed $9,000 on January 30, 2002 and agreed to pay 14% simple interest on the balance outstanding at any time. He paid $5,000 on March 9, 2002 and $2,500 on May 25, 2002. How much did he have to pay on June 30, 2002 in order to pay off the debt?
  • 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.

Empty timeline showing key dates from problem

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

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

Business Mathematics Copyright © 2020 by BCIT is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book