Issue with sort column

Hello !   I try to sort my column EOY_DATE by DATE, but I have one issue ...  I need one column with date for week, and weekend for weekend.    But in my graph I need to sort by date ! is poss...