Dates in Table Headers

[mrsbrannon]

Hello all,

Is it possible to have dates automatically update in table headers? I read somewhere else that you cannot formulate a header. I track days on time sheets and hours worked each day. I need to keep the headers in order to do my totals, but get tired of having to change the dates every single week. Originally I planned to do a formula of F3+1, adding the date of the previous header across, but that did not work (guess that's because formulas don't work in table headers).

I hope this makes sense.

---

 

[DRSteele]

Welcome to the Forum.

I surveyed some sources on the internet and I've found that Table Headers must be text. I also tried to type and paste all kinds of things into the headers and I see they must not only be text but unique text as well. Sorry.

 

[Fazza]

If you describe what is wanted, it can be coded.

Could be as simple as a double click on the first header cell that is a date would initiate the code have it update the cell text to the most recent Sunday/Monday/whatever, and change all the other date headers too.