Formula help | Replacing an end date within accrued interest formula

[Morgan McCloskey]

I need to calculate accrued interest with an end date of 10.27.2017 rather than "TODAY" How do I replace the date in this formula?

=FV(0.1/365,DAYS(TODAY(),B5),0,-D5)

Any help would be appreciated! Thank you!

[#2 · Accepted solution]

Hello,

put the desired date into a cell, for example A1, then replace Today() with A1

=FV(0.1/365,DAYS(A1,B5),0,-D5)

This way you can quickly change the date without having to change the formula. If you want to hard-wire the date into the formula, you can use the Date() function. The parameters for Date() are year, month, day, in that order, so

=FV(0.1/365,DAYS(date(2017,10,27),B5),0,-D5)

Let me know if that helps.