Formula to Calculate Amounts at 30, 60 and 90 Days

[lzweifel]

Hello, I know this is a simple one, but I could please use your help....

I would like a formula that IF an invoice number and amount, with date are typed in then the amount would re-populate in the appropriate column. CURRENT, Over 30, Over 60 and Over 90.

For example

Date for Invoice is August 6, 2021.... original amount is $1000 — calculating based on current date it is now over 90 days and would appear in that column, leaving all the others blank.

 

[BigBeachBananas]

What do you mean by "current date", does it stay fix or it changes every day (i.e =TODAY() function)?

 

[lzweifel]

What do you mean by "current date", does it stay fix or it changes every day (i.e =TODAY() function)?

Current date would be date of opening. So, today is Jan 5, if I open the workbook today then an invoice date of Dec 4 would now be in the column OVER 30, an invoice dated December 31, would be in the column CURRENT. So, based on today's date (computer date) and calculating from the invoice date (which once entered does not change)

 

[lzweifel]

Can I just go A1+30, plus 60 etc.

But, I want it to move from CURRENT to OVER 30, OVER 60 etc. So the same invoice dated yesterday, today would be in current... but 65 days from now it would appear in the OVER 60 column.