Date in a header

Fred_Schieferstein 

Hello Fred, your answer was not particularly helpful, because you already wrote the hint that CTRL + 1 does not work in your original post.

My answer here refers to the headers in formatting tables. Headers in printings are not discussed here. Unfortunately, you did not give an answer to my question.

The data in the header is converted to static values when the table is created. This means that formatting the number format is no longer possible. If you try to make a header row out of a formula (e.g. =TODAY()), you will get the following error:

Formulas or rich data types can't be used in the header row of a table. Convert them to static values before you create the table.

This is quite logical. A date in Excel is actually a number. From 31/12/1899, a day is added to 1. The 44932 stands for 06/01/2023. There are countless format display options for the date format. What should your table field be called now? =myTable[06/01/2023] or =myTable[44932]?

There is still one piece of good news though. While experimenting, I found that you can change the date format, but it is not directly displayed as a new format. You can help yourself with a workaround.

I have written a help line under the table in which I output the values with =VALUE(A1:D1) - i.e. the header lines of my table with the dates. Provided the conversion to values has worked, there are then numbers in the row. Then you can change your number format in the header rows. Then copy the help line and paste it into the header line with Paste Values. Then you have changed the number format of the header.

I hope this was helpful for you.