Formulas for the List Headers

[San]

Would someone be able to give me a hand with the Excel list? Here is my problem: I would like to update a template I use monthly to create a financial projection report. One cell on the report indicates the reporting date. I need to report twelve months projection. The report header has twelve columns with formulas related to the reporting date in their headers. As soon as the report date updated all columns update their names as well. Please see the attachment, EXAMPLE 1. I would like to convert this report table to the list, but as soon as do this my formulas dissapear from the list headers and live just names. Please, see the attachment EXAMPLE 2. I fould tricky way to avoid this problem by adding additional row to the header and living names outside of the list, but I don't like it and it also affects the report view.

1. Do you know if Excel list headers can include any formulas? (I can't find this information in the Excel Help).
2. If they can, how can I load formulas?
3. If they cannot, do you have any idea how I can let Excel update columns names according to the reporting date?

Thank you.