Finding the beginning/end date when given a date and the number of days

Sometimes we are asked to find a beginning (or end) date when we are given a date and the number of days in between.

For example, if you were given the following problem:

On June 26, 2013, $1,000 was borrowed at a simple interest rate of 4.55%. On what date was the loan repaid if the amount of accrued interest was $11.47?

When solving for t, you get an answer of t = 92 days.  However, you are asked for the date the loan was repaid.

We can use MS Excel to calculate the date the loan was repaid.

Enter the date the money was borrowed (June 26, 2013) into cell B2.  To calculate the day the loan was paid back (92 days later) we can use the formula =B2 + 92 and Excel will calculate the date the money was paid back. See the example below.

adding days to date - 2 (formulas)       adding days to date - 2

Calculating a New Date – given a Date and the number of days – Template

For more information on adding and subtracting dates, go to the Microsoft support page

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

Using Excel in Business Math Copyright © by Lisa Koster is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book