Thanks for the input but it returns the same #VALUE! error

---------- Post added at 01:56 PM ---------- Previous post was at 01:54 PM ----------

I've done that and it doesn't convert into date format, not only does it not correct the mdy to dmy format, but the resulting output reading same as it did before can't then be changed into other date layout format, and as such the for,ula still errors