i have a cell contents that look like this Sep 27th 2023 09:21:00. I use this formula DATEVALUE(MID(E2,5,2)&" "&LEFT(E2,3)&" "&MID(E2,10,4)) to get the date 9/27/2023. However if the days are lower than 10 it will give me a value error. Example: a cell contents with a date like this Sep 6th 2023 10:22:00 gives me the value error. is there a formula i can use that will capture the date no matter the amount of days?