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.

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