Quote Originally Posted by NBVC View Post
The dates in column M are currently text strings... to fix that, select column M and go to Data|Text to Columns, click Next twice and in 3rd window, select Date in the column data format section, then select MDY or DMY based on your regional setting.. then your formulas should show results... but you should use defined range instead of whole column M:M for efficiency.
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 formula still errors