Tag Archives: date format

Excel: Date Format with Day Name

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

Posted in Tech Tips | Tagged , , | Leave a comment