If statements

[jamie_lo75]

=IF(ISBLANK(RC[-1]),"Not Done",IF(RC[-1]+730<=TODAY(),"Expired",IF(RC[-1]<=TODAY()+30,"About to Expire","Valid")))

I need help guys, not sure how to explain, but I want the if statement to show EXPIRED after 2 years and About to Expire 1 month before but 2 years
*The Radiation Safety Column should have 2 years validity so I want to show, VALID, ABOUT TO EXPIRE & EXPIRED

 

[Georgiboy]

Like the below?

Book1
	A	B
1	Date
2	27/06/2021	Expired
3	28/06/2021	Expired
4	29/06/2021	Expired
5	30/06/2021	Expired
6	01/07/2021	Expired
7	02/07/2021	Expired
8	03/07/2021	Expired
9	04/07/2021	Expired
10	05/07/2021	Expired
11	06/07/2021	Expired
12	07/07/2021	Expired
13	08/07/2021	Expired
14	09/07/2021	Expired
15	10/07/2021	Expired
16	11/07/2021	Expired
17	12/07/2021	Expired
18	13/07/2021	Expired
19	14/07/2021	Expired
20	15/07/2021	Expired
21	16/07/2021	Expired
22	17/07/2021	Expired
23	18/07/2021	Expired
24	19/07/2021	Expired
25	20/07/2021	Expired
26	21/07/2021	Expired
27	22/07/2021	Expired
28	23/07/2021	Expired
29	24/07/2021	Expired
30	25/07/2021	Expired
31	26/07/2021	About to expire
32	27/07/2021	About to expire
33	28/07/2021	About to expire
34	29/07/2021	About to expire
35	30/07/2021	About to expire
36	31/07/2021	About to expire
37	01/08/2021	About to expire
38	02/08/2021	About to expire
39	03/08/2021	About to expire
40	04/08/2021	About to expire
41	05/08/2021	About to expire
42	06/08/2021	About to expire
43	07/08/2021	About to expire
44	08/08/2021	About to expire
45	09/08/2021	About to expire
46	10/08/2021	About to expire
47	11/08/2021	About to expire
48	12/08/2021	About to expire
49	13/08/2021	About to expire
50	14/08/2021	About to expire
51	15/08/2021	About to expire
52	16/08/2021	About to expire
53	17/08/2021	About to expire
54	18/08/2021	About to expire
55	19/08/2021	About to expire
56	20/08/2021	About to expire
57	21/08/2021	About to expire
58	22/08/2021	About to expire
59	23/08/2021	About to expire
60	24/08/2021	About to expire
61	25/08/2021	About to expire
62	26/08/2021	Valid
63	27/08/2021	Valid
64	28/08/2021	Valid
65	29/08/2021	Valid
66	30/08/2021	Valid
67	31/08/2021	Valid
68	01/09/2021	Valid
69	02/09/2021	Valid
70	03/09/2021	Valid
71	04/09/2021	Valid
72	05/09/2021	Valid
73	06/09/2021	Valid
74	07/09/2021	Valid
75	08/09/2021	Valid
76	09/09/2021	Valid
77	10/09/2021	Valid
78	11/09/2021	Valid
79	12/09/2021	Valid
80	13/09/2021	Valid
81	14/09/2021	Valid
82	15/09/2021	Valid
83	16/09/2021	Valid
84	17/09/2021	Valid
85	18/09/2021	Valid
86	19/09/2021	Valid
87	20/09/2021	Valid
88	21/09/2021	Valid
89	22/09/2021	Valid
90	23/09/2021	Valid
91	24/09/2021	Valid
92	25/09/2021	Valid
93	26/09/2021	Valid
94	27/09/2021	Valid
95	28/09/2021	Valid
96	29/09/2021	Valid
97	30/09/2021	Valid
98	01/10/2021	Valid
99	02/10/2021	Valid
100	03/10/2021	Valid
101	04/10/2021	Valid
Sheet1

Cell Formulas
Range	Formula
A2:A101	A2	=SEQUENCE(100,1,44374,1)
B2:B101	B2	=LET(d,A2#,MAP(d,LAMBDA(x,IF(EDATE(x,24)<=TODAY(),"Expired",IF(EDATE(x,23)<=TODAY(),"About to expire","Valid")))))
Dynamic array formulas.

 

[jamie_lo75]

thanks!!

 

[Georgiboy]

You are welcome, thanks for the feedback.