DATEVALUE() returns #VALUE despite text format. DATE() returns #REF despite number format

I am trying to convert a string date (ie. "19/07/2021") to date format. I have tried the following steps: 1. DATEVALUE returns a #VALUE error, although I have used ISTEXT to verify that the target c...