Formula required for conditional formatting

[Arts]

Hi all

I was trying to run a basic formula to match two dates and if they matched the cell would then highlight. (I have a a huge row of dates)

I had Mar 25 in one row and Mar 25 in another row (E21 and L21) and these were not matching. What I then found was that the date of these were slightly different as the formatting was showing Mar 25 the actual dates were 02/03/25 and 18/03/25.

If I could just match the month and year and exclude the day that would be super helpful, so if both values have Mar 25 that would be seen as a match irrespective of the day.

As always appreciate any assistance with this.

 

[AlanY]

you can use the =EOMONTH() function effectively ignore the day with just year and month.

Book1
	A	B
1	25-Mar-25	05-Mar-25
2
3		FALSE
4		TRUE
Sheet1

Cell Formulas
Range	Formula
B3	B3	=AND(A1=B1)
B4	B4	=AND(EOMONTH(A1,0)=EOMONTH(B1,0))

 

[Arts]

you can use the =EOMONTH() function effectively ignore the day with just year and month.

Book1
	A	B
1	25-Mar-25	05-Mar-25
2
3		FALSE
4		TRUE
Sheet1

Cell Formulas
Range	Formula
B3	B3	=AND(A1=B1)
B4	B4	=AND(EOMONTH(A1,0)=EOMONTH(B1,0))

Brilliant thank you so much! Does exactly what I needed.

 

[AlanY]

Brilliant thank you so much! Does exactly what I needed.

you're welcome