Matching cells returning FALSE when comparing the "Year" in dates

[Monty85]

Can anyone assist with a formula that will work in the below example. I need to compare a list of dates against another source that has intermittent data - dates are in text format, in YYYY,MM,DD format and half the data is the year only.

I want to compare the Year between the two data sets but im not sure if i'm going about it the right way.

MERCER_BT_AUS_PEP_03042023 - Validations (less formulas).xlsx
	A	B	C	D	E
1	Date_1	Year Only	Date_2	Year Only	Check
2	15/04/1970	1970	1970	1970	FALSE
3	1/05/1989	1989	1989/05/01	1989	FALSE
4	25/03/1999	1999	1999	1999	FALSE
5	15/07/1986	1986	1986/07/15	1986	FALSE
6	8/09/1967	1967	1967	1967	FALSE
Sheet5

Cell Formulas
Range	Formula
D2:D6	D2	=LEFT(C2,4)
E2:E6	E2	=D2=B2
B2:B6	B2	=YEAR(A2)

 

[JvdV]

You are comparing a string vs an integer. Maybe just add something like:

=--RIGHT(C2,4)

 

[Monty85]

You are comparing a string vs an integer. Maybe just add something like:

=--RIGHT(C2,4)

Well that was simple.

Thanks, that did the trick.