0
   

interest after 30days

 
 
joeyct
 
Reply Fri 13 Aug, 2010 12:18 am
I need a formula for money that is owed (job) and it has a start date.
The invoice is 30 days payable but after that there is a 0.5% late fee on the total amount owing. I have the spreadsheet working but cannot get it to calculate interest after the first 30 days.
row 1 todays date
row 2 date of job done
row 3 money owing
row 4 interest rate
row 5 Interest amount only
row 6 Total owing

this is repeated in other columns as different jobs are added. all the same customer
My thanks in advance

Joeyct
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 482 • Replies: 1
No top replies

 
PUNKEY
 
  1  
Reply Fri 13 Aug, 2010 11:06 am
After Amount due, you need a due date. Then +30 days after that, the interest penalty starts.
0 Replies
 
 

 
  1. Forums
  2. » interest after 30days
Copyright © 2025 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 07/08/2025 at 10:13:32