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

Related Posts:

  • No Related Posts
This entry was posted in Tech Tips and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *