Forum Discussion
Formula help | Replacing an end date within accrued interest formula
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!
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.
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.
