=QUERY(B2:B33, "SELECT * FORMAT B 'd-mm-yyy (ddd)'")

(selects a range and changes its date format)