An excel formula needed to determine T/F on dates

[ItalianPlatinum]

Hello,
I need some help trying to create a formula that will identify if the date1 and date2 don't equal next BD -2 (i have that formula in a cell to reference).

There are a few variables though:

1. indicator "I" will have the date 2 as 0
2. indicator I and A date 1 and date 2 will be on a last BD of prior month -1 date on every BD 1 (this is ok). (i also have that formula in a cell to reference)

I know a lot going on. ideally would like 1 formula unless i need multiple helper columns to bring it together?

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Account	Indicator	Date 1	Date 2	Formula (HELP)	Desired Result		Next BD -2	20230731	LAST BD PM-1	20230730
2	1	F	20230731	20230731		FALSE
3	2	F	20230731	20230731		FALSE
4	3	F	20230731	20230731		FALSE
5	4	F	20230731	20230731		FALSE
6	5	F	20230731	20230731		FALSE
7	6	F	20230731	20230731		FALSE
8	7	F	20230730	20230730		TRUE	TEST
9	8	F	20230730	20230731		TRUE	TEST
10	9	F	20230731	20230730		TRUE	TEST
11	1	I	20230731	0		TRUE	TEST
12	2	I	20230729	0		TRUE	TEST
13	3	I	20230730	0		FALSE
14	4	I	20230730	0		FALSE
15	5	I	20230730	0		FALSE
16	6	I	20230730	0		FALSE
17	7	I	20230730	0		FALSE
18	8	I	20230730	0		FALSE
19	9	I	20230730	0		FALSE
20	1	A	20230730	20230730		FALSE
21	2	A	20230730	20230731		TRUE	TEST
22	3	A	20230731	20230730		TRUE	TEST
23	4	A	20230729	20230730		TRUE	TEST
24	5	A	20230730	20230729		TRUE	TEST
25	6	A	20230730	20230730		FALSE
26	7	A	20230730	20230730		FALSE
27	8	A	20230730	20230730		FALSE
28	9	A	20230730	20230730		FALSE
Sheet1

 

[ItalianPlatinum]

Thanks to both. I did Formula2 and it ended up working.

 

[Tetra201]

Another approach:

Range("E2").FormulaArray = "=OR(IF(OR(RC[-3]={""A"",""I""}),R1C11,R1C9)<>CHOOSE({1,2},RC[-2],IF(RC[-1],RC[-1],RC[-2])))"
Range("E2").AutoFill Destination:=Range("E2:E" & Range("A" & Rows.Count).End(xlUp).Row)

 

[ItalianPlatinum]

Thanks everyone for being so helpful!

 

[Tetra201]

Glad we could help.