Hi. I'd like assistance with making Flags for the next 5 separate weeks.
Thus a flag for the current week, next week, the week after next, and so on, going ahead 5 weeks.
I already have the ranges for my week using
Date(WeekStart(TempDate) + 1, 'M/DD') & '-' & Date(WeekStart(TempDate) + 6, 'M/DD') as WeekRange,
, but I'd also like that week Range to be listed as the Label for each of those week flags.
Thus, if I have a table, each column will include data from week 1 (current week), week 2 (next week), and so on using the WeekRange in the label.