Stored as date format, cut at comma

If you go to Sales in that attached ss, you will see the cell i have highlighted yellow, can someone make that cut Monday out of col a, but for consistency down the range, cut just before comma, also i belive that the col a is stored as date, causing it to return digits

Many thanks
The-Howl-Sales-Kat.xlsx