hello, I am in need of some assistance. I am working with a table of data, which I am trying to convert into an actual table format. The column headers are formula-driven dates. however, when I convert the data into a table, I lose the formula and the headers turn to text. Even if I try to manually enter a date, the table format seems to convert it to text. What am I doing wrong? I hope someone here can help me out?
Hi Dernan, you can not use either formulas or dates column headers to tables. You are doing nothing wrong, its just how Excel works.
When I am faced with this issue myself what I tend to do is add a new row just above the table headers. As this row is not part of the table, you can include formulas or dates, and you can also use it to drive other formulas that might be included within the table.
I don't think this is the news you wanted to hear, but there are always workarounds in Excel :-)
Working that way, the table headers can not be dynamic, which is really a function I need from the tables. But thank you for the answer