Forum Discussion

Copper Contributor

Feb 14, 2018

Solved

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 apprec...

Formulas & Functions

Need Help

IngeborgHawighorst
Feb 15, 2018
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.

IngeborgHawighorst

MVP

Feb 15, 2018

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.