###Excel Date Format Option 1
Use the `WEEKDAY()` Function to get the serial number of the day of the week.
###Excel Date Format Option 2
Format the existing cells as `ddd dd/mm/yyyy hh:mm` to show the day.
Excel » format cells » custom format / custom date » format as above