Let's say cells A1 and A2 have these values:
13 Jan, 02:21 am
12 Jan, 10:15 pm
And many more values like those below in that column.
What formula could I use so that the B column would look like this?
I'm confused about DATE(), DATEVALUE(), TIMEVALUE(), etc.
In PHP it is so much easier: https://www.php.net/manual/en/function.strtotime.php