1. When entering the date in the first column, also enter it in the second column. Format the second column to display day only. Select column, Ctrl+1, on the numbers tab select the bottom option and enter "dddd".
2. Start recording a macro, select the column you want to sort, apply filter (top menu Data), change filter to descending order, remove filter, stop recording.
Adjusting code: Hit Alt+F11 to view the recorded code, copy the code except the first line. Double click the appropriate sheet on the left side, paste your recorded code and put the following lines at the top:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns(1)) Is Nothing Then Exit Sub
Change the "1" in the 2nd code line to the column number you applied the autofilter to.
Let us know if you would like more assistance.