Manipulating Dates as Text?

Hi

I have some day values in a spreadsheet that have been stored as text eg. 1st, 2nd, 3rd... 31st.

So I can easily strip off the ordinals with LEFT(A1, LEN(A1)-2) to give just the day number as text.

I'd like to take a properly formatted date from another cell, remove the day, and replace it with the day number above, for example:

Cell A1: 10th
Cell A2: 03/07/20
Result..
Cell A3: 10/07/20

Of course Cell A2 is a real date stored as a number value, so I cannot manipulate it as a string.

The results in A3 also needs to be a real date (not a string) so that if can be sorted in the future.

Any advice on how I can achieve this please?

Cheers
Robin

You both made that look so easy :-)

Thank you very much