Days Aging Formula (# of days overdue)

[Robert_Conklin]

I have a list of past due invoices. I have a PO Date (column f) and I am wanting to add a column for Aging Days (column H) that will tell me how many days have gone by from the PO date. In column I, I would like it to tell me if the invoice is past due or not past due. Any help would be greatly appreciated.

 

[Taul]

Hi,
Is this what you need?

Book1
	F	G	H	I
1	Date		Ageing Days	Status
2	28/03/2021		10	overdue
3	29/03/2021		9	overdue
4	30/03/2021		8	overdue
5	31/03/2021		7	overdue
6	01/04/2021		6	overdue
7	02/04/2021		5	overdue
8	03/04/2021		4	overdue
9	04/04/2021		3	overdue
10	05/04/2021		2	overdue
11	06/04/2021		1	overdue
12	07/04/2021		0	overdue
13	08/04/2021		-1	Current
14	09/04/2021		-2	Current
15	10/04/2021		-3	Current
16	11/04/2021		-4	Current
Sheet1

Cell Formulas
Range	Formula
H2:H16	H2	=TODAY()-F2
I2:I16	I2	=IF(H2>=0,"overdue","Current")

 

[Robert_Conklin]

Yes. That is perfect! Thank you very much for your time!

 

[Robert_Conklin]

One question, will this automatically update if I open the report tomorrow?

 

[Taul]

Hi,
Yes, it will update tomorrow. The formula is using "Today()"
try this formula in a cell and check it again tomorrow.

=today()

 

[Robert_Conklin]

Thank you.