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.
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.