Divide data according to weekdays

I have database(database is in date format) containing yearly data(in csv format). How can I divide the data according to weekday and then according to days