=today() issue

[Zebari480]

When I code =today() in a worksheet Column header I gat back 00/01/1900 but when I code =today() any where else on the worksheet I get back 16/09/2021 Is there a fix for the first?

[#2 · Accepted solution]

@Zebari480 

You cannot use formulas in the header row of a table, they must be fixed text values.