Sorting assignments chronologically in a row

[Panglossian]

Hey guys, I have a spreadsheet of assignments to students and I wanted to categorize them by assignment start date, and end date for each assignment. The problem is, the person who made the spreadsheet for me didn't organize the dates correctly so Assignment 1 might actually be Assignment 2 because the dates aren't in chronological order right now.

I need to organize everyones info in chronological order for each assignment, and some assignment both start on the same date so the preferable thing to do would be to use the earliest end date as Assignment 1 and the later one as Assignment 2.

In the workbook attached it would be like
Testbook.xlsx

So in this case, John Marks and Bob Marley need to have their two assignment dates switched. Bart Simpson needs to get his assignment end dates switched because the earlier end date was 7/8/10 and the later one was 7/20/10 so the earlier one is Assignment 1 and the later one is Assignment 2.

Some people have more than 5 assignments, and some people only have one.

I tried using conditional formatting to try and find any dates that were less than the first two and sorted through those but I never got any matches probably because my formatting formula was wrong even when dragged down. If anyone has any ideas that'd be awesome!

[FDibbins]

HI, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[Panglossian]

Sorry about that! I added a sample workbook and edited the explanation.