Add blank row in excel spreadsheet based on day of week

Help - I have a few massive excel spreadsheets created by importing data from another source via copy/paste and need to separate out the data by week (Mon-Sun) - is there a simple (read easy for exce...