Dynamic Column Names

[Taxautomation]

We only take into consideration work weekdays during the month. These days are numbered from the start of the start to the end of the month. For example, October has 23 days in which a daily report is needed. I want my columns to be dynamic relative to the day of the month we are in. 

I have data that looks like this, where [ABC] is yesterday, and [XYZ] is the day before yesterday.

XYZ 3	ABC 4
3	5
2	7

Ideally, my output would look something like this. Where I don't need to do manual input to change column names.

Workday 06_9-30-24	Workday 07_ 9-30-24
3	5
5	4

If it takes holidays into consideration even better.

[KGT · Accepted solution]

Look into Business Days solutions. There are a couple of macros floating around for it

The way I see this being successful is by labelling the day of the month and essentially using a lookup table. You will need to connect to your local holidays to filter that out. Either an API, or just download and parse from a holiday site.

I've attached a workflow with some techniques that I would use. It is definitely not a finished product, just a couple of ideas. (and a dynamic rename will go on the end).