Power Query - Column Code Help

[girltoni]

Hello,

I have a column that pulls the data in this format... the dates are dates and the other is days late or day early depending on if there is a negative. I am needing to keep both parts in the same column; however, I need to change the format for the date to MM/DD/YYYY. Unfortunately, the Column from example is not detecting what I need. And I am not certain how to write the code for it. I do have "potential" parts to use, but do not know enough about coding in Power Query to make it work for my needs. For the date, I was thinking I could use text.middle Text.Middle([#"MyColumnName"], 6,2, "/" Text.Middle [#"MyColumnName"], 9,2 "/" Text.Middle [#"MyColumnName"], 1,4) to extract the middle, then last, then first sections for the date that are needed. Then I would need to join them with the "/" somehow. And then I need to else... write the text instead if it does not contain the "-".... I am not sure if the logic is on point and would really appreciate any help!

2020-05-08
2020-04-23
-117
2020-05-04
2020-05-11
2020-05-11
-90
2020-05-11
2020-04-29
2020-05-25
2020-05-11
-85
-85
-85
2020-05-20
2020-08-05
2020-08-27
2020-08-13
-34
-34
2020-07-10
-26

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

I ask because when I copy and paste your column of data to Excel it automatically converts them to dates and I cannot then replicate your issue.