Generate a list of month end dates in the year and 6 business days before it

[wonka1234]

Hi.

How can I generate a list for the year of month end dates and the date of 6 business dates before it? I dont want to hardcode it.

Ie 

2023-01-31	2023-01-24
2023-02-28	2023-02-21

Bonus question - can this be done for Quarter ends too, ie Jan 31, Apr 30, Jul 31, Oct 31.

Thanks.

[ChrisTX]

Click the Generate Rows tool under the Preparation palette, then click Open Example

This post has links to some examples for dates: Dynamic quarter date need to be created - Alteryx Community

Chris

[DataNath · Accepted solution]

@wonka1234 This ought to be fully dynamic and provides month end, month end-6 and quarter end. Think there's likely a cleaner/simpler way of doing this but this should do the trick.