# Formula to Calculate Amounts at 30, 60 and 90 Days

#### lzweifel

##### Board Regular
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.

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
What do you mean by "current date", does it stay fix or it changes every day (i.e =TODAY() function)?

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)

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.

#### Attachments

• Screen Shot 2022-01-05 at 2.39.50 PM.png
38.3 KB · Views: 29

Replies
4
Views
667
Replies
3
Views
245
Replies
2
Views
124
Replies
4
Views
302
Replies
1
Views
173

1,203,752
Messages
6,057,152
Members
444,908
Latest member
Jayrey

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back