"thehed" wrote:
=FV(annualRate/365, currentDate - startDate, 0, -principal)

I am using the above formula as suggested,
it works fine for now.

I am working on the formula posted by JoeU2004,
however [...e]ither the formulas don't translate
or I fat fingered the formula entry.

I don't understand. The above formula is (one of) the formula that I
posted.

Do you mean that you are trying to get the FV(RATE(...),...) formula to
work?

Or do you mean that you are trying to get Fred's formula to work?

If the interest rate that you have is an APY (compounded rate), which is
likely, Fred's formula is the better one to use.

Show us what you are trying that does not work, and we can help you.


----- original message -----

"thehed" wrote in message
...

Maybe I could use the FV formula with the interest calculated for an
equivalent daily rate and then use the starting date and =today() to
find difference in days from start to present and plug those number of
days into FV formula.

Yes, you could do that. It would be simply:

=FV(annualRate/365, currentDate - startDate, 0, -principal)


I am using the above formula as suggested, it works fine for now.

I am working on the formula posted by JoeU2004, however I use Excel at
work and OpenOffice at home. Either the formulas don't translate or I
fat fingered the formula entry.

Thanks for the help.