Searching for values with dates and letters

[MustaphaOj]

Hi All,

I have a formula but it’s half complete. I’m currently able to search for a dates after a certain using the “DATEVALUE” function but the data I’m searching through has the letter “A” in some columns next to the date. I would like to be able to search these dates too. As it stands my formula is

=IF(M24>DATEVALUE(“24/05/2019”), “yes”, “no”)

But if I have a date that reads “27/06/2024 A” how do I get that to also display yes or no?
thanks in advance

 

[Rick Rothstein]

Are you saying the "A" is in a different column than the date or is the "A" joined with the date (with a space separating them) within the same cell?

 

[MustaphaOj]

Good Afternoon Rick,

they are in the same column together so for example.

27-06-21 A

13/08/19

06/03/20

 

[Rick Rothstein]

Try this formula (assumes dates are in Column A... change as needed)...

=IF(M24>DATEVALUE(0+LEFT(A1,8)), “yes”, “no”)

 

[MustaphaOj]

Thank you for this Rick however I am still getting an error. In Column M is where the dates are mixed with the letter A. So Ideally the formula should read the whole column looking for dates past 24/05/19 with and without the letter A. Sorry if i wasn’t clearer before.