Tech Support Forum banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Moderator , Microsoft Support, MS Office Pro
Joined
·
2,543 Posts
Hi Cassfax,

Is that 2% per month simple interest or compunding interest?

Where the Invoice Date is in A1 and the Invoice Amount is in B1:
For simple interest calculated monthly-
=B1*(1+DATEDIF(A1,TODAY(),"m")*0.02)
For compound interest, where the annual rate of interest compunds to 24%-
=FV(1.24^(1/12)-1,DATEDIF(A1,TODAY(),"m"),0,-B1)
For compound interest, where the monthly rate of interest is 2%-
=FV(0.02,DATEDIF(A1,TODAY(),"m"),0,-B1)
 

·
Registered
Joined
·
3 Posts
Discussion Starter · #3 ·
Thanks for your help. It worked like a charm!
One more question, I want the whole row to change colour when the invoice is over 30 days. I've figured out how to make the cell change colour but not the whole row. Can you help with this?

Thanks
 

·
Moderator , Microsoft Support, MS Office Pro
Joined
·
2,543 Posts
Hi Cassfax,

I've figured out how to make the cell change colour but not the whole row. Can you help with this?
You apply the same conditional format to every cell on the row.
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top