How can I create this output using Generate Rows or Multi-Row formula?

Question

Hello!

I have this as my input

Weeks OutWeeks Out DateData Through08/25/20258/24/202518/18/20258/17/2025

I want to expand my weeks out date so that multiple dates are showing. Here is the desired output. Not sure how to go about it.

Weeks OutWeeks Out DateData Through08/31/20258/24/202508/30/20258/24/202508/29/20258/24/202508/28/20258/24/202508/27/20258/24/202508/26/20258/24/202508/25/20258/24/202518/24/20258/17/202518/23/20258/17/202518/22/20258/17/202518/21/20258/17/202518/20/20258/17/202518/19/20258/17/202518/18/20258/17/2025

abacon · Accepted Answer

@bryanmac_92 Here is a way to do it.

Get the date fields into the date format then use a generate rows tool to add a date until it's a week out for each record.

There are other ways to reformat the dates but this is the easiest for me.

Bacon