future value function for compound interest

[frustrated wife]

How would I use the FV function for compound interest on an investment
maturing in 30, 60, or 90 days? So, for example, where would I plug in the
following values:

$1,000 investment
1.39% interest rate
30 day

I need to do the same for 90 days, 60 days, 6 months and 9 months.

Thanks!

 

[Spiky]

How would I use the FV function for compound interest on an investment
maturing in 30, 60, or 90 days? So, for example, where would I plug in the
following values:

$1,000 investment
1.39% interest rate
30 day

I need to do the same for 90 days, 60 days, 6 months and 9 months.

Thanks!

If those 3 number facts are in A1:A3....
=FV(A2,A3/30,,-A1)

I assumed the rate was a 30 day rate based on your comments. You'd
have to adjust the A3/30 to match the rate if necessary.