Date generation

[ABC_Anonymous]

Hello, I wanted to create an iterative macro to generate the closing dates of 2 years before a specific date for Example : for the date 2024-06-30

Input :

QY	Date
Q3_2024	2024-09-30

Output :

QY	Date
Q3_2024	2024-09-30
Q3_2024	2024-06-30
Q3_2024	2024-03-31
Q3_2024	2023-12-31
Q3_2024	2023-09-30
Q3_2024	2023-06-30
Q3_2024	2023-03-31
Q3_2024	2022-12-31
Q3_2024	2022-09-30

[alexnajm · Accepted solution]

You shouldn't need an iterative macro - the Generate Rows tool should work! Just do a bit of work after (or adjust the logic) to make sure you are getting the actual end of the month rather than the 30th