Invoice Due Dates

Hi there,

 

I have the following data and am trying to figure out the formula for each due permutation where if true then copy the balance amount in the relevant cell?

 

 



Invoice Date Balance Due Next Month Due This Month Overdue > 30 days Overdue 31-60 days Overdue > 61-90 days Overdue 90+ days
17/02/16 5,425.44            
09/05/16 46,466.11            
21/08/16 646,477.00            
01/11/16 62,425.19            
04/01/17 31,500.20            
07/02/17 356,111.90            
10/03/17 515.09            
13/04/17 5,135,146.12            
14/05/17 356,138.71            
20/06/17 9,897,486.55            
06/07/17 76,777.84            
19/08/17 987,529.04            
28/09/17 123,098.34            

By: Monty69

Leave a Reply

Your email address will not be published. Required fields are marked *