03 June, 2025

Excell: Show the name of the day and the date

Formatting days and dates is not as complicated as I thought. 

Rightclick on the cell, choose "Format Cell". This will open the dialog where you can define what you want to see. 

The cell could  be formatted like this:

dddd dd.mm 

  • dddd = will give you the entire name of the day, e.g. monday.
  • dd = will give you the day of the month.
  • mm = will give you the month
If you add yy to the formula you'll get the year too.

Now you can so something along these lines:



No comments: