Opening the data in the Power Query editor and change the column type to date.
We have null values in the date field. We want to replace the nulls with the first non-null value above. Use the Fill Down option on the Transform tab of the Power Query editor:
Row 2 had the value from row 1, while rows 4 & 5 have values from row 3.