Date Column with non-date text

[Noah]

Hello everyone.

I have a column with the original intention of it having to be a date column. However, the spreadsheet owners also add other things such as "N/A, Cancelled"and other things they need.

My question is, how would I go about creating another column with just the dates? In fact, there's about 5 different columns in which this happens and there's also more informative words they enter into these columns.

Thank you for any help you can provide!

[Greg_Deckler]

@Noah Try this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ31DcyMDJRitWJVvLTdwTTzol5yak5OakpYJ6hkb4RVE0sAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.FromText( [Column1] )),
    #"Replaced Errors" = Table.ReplaceErrorValues(#"Added Custom", {{"Custom", null}})
in
    #"Replaced Errors"

[Noah]

Do I replace all of the "Column1" with my actual column names?