I was recently assigned an assignment for class (to do on excel not alteryx.... this is just for fun). We were told to clean a data set, and since I am trying to learn alteryx I figured this would be good practice. I got most of the data cleaned, but the two parts that I cannot figure out is deleting rows that contain a blank or null value and formatting dates in a column that were input in several different formats. I am attaching the dataset to this along with my current work on alteryx. You can see where I was stuck on the date function.
If you need additional information please let me know, otherwise I would really appreciate the help.