cannot change date format

  I needed to change the date in a consistent format. first, I applied simple cell date format but it did not work. then I applied the DATEVALUE function which resulted in errors. I also appli...