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.
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.
