30-60 -90 Days - IF Function

[Jatli]

Hi

I am trying to do a function where if invoice is 30-60 days the cell will say30 - 60 days, if invoice is 60-90 days, cell will say 60 to 90 days and if invoice is over 90 days, cell will say Over 90 Days. Here is the formula I have put it =IF(H3>29,"30-60 Days",IF(H3>59,"60-90 Days",IF(H3>90,"Over 90 Days","")))

It is not working as even when it is over 60 days it will still say 30-60 days. If I put <60 in the first one then cells that are only 1 day old will say 30-60 days. Please help.

 

[BSALV]

amoverton2 - 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1					0	31	61	90	10000
2	Invoice Amount	Date (european)			0-30 days	31-60 days	61-89 days	90-9999 days
3	$ 74.00	1/10/2021						$ 74.00
4	$ 111.00	7/10/2021						$ 111.00
5	$ 148.00	8/10/2021						$ 148.00
6	$ 185.00	9/10/2021					$ 185.00
7	$ 222.00	1/11/2021					$ 222.00
8	$ 259.00	6/11/2021					$ 259.00
9	$ 296.00	7/11/2021				$ 296.00
10	$ 333.00	8/11/2021				$ 333.00
11	$ 370.00	1/12/2021				$ 370.00
12	$ 407.00	6/12/2021				$ 407.00
13	$ 444.00	7/12/2021			$ 444.00
14	$ 481.00	8/12/2021			$ 481.00
15	$ 518.00	1/01/2022			$ 518.00
16	$ 555.00	6/01/2022			$ 555.00
17	$ 592.00	4/04/2022
18
Blad3

Cell Formulas
Range	Formula
E2:H2	E2	=E1&"-"&F1-1& " days"
E3:H17	E3	=IF(MEDIAN($B3+E$1,$B3+F$1-1,TODAY())=TODAY(),$A3,"")
I17	I17	=IF(MEDIAN($B17+I$1,$B17+J$1,TODAY())=TODAY(),$A17,"")