Increment by 1 evey time cell greater than 18k or not blank

[oneillp111]

I am trying to add an index or grouping every time a cell is not blank. In the image below I have a multi row formula that adds a month to the Minimum new date value every time the running total exceeds 18k.  Ideally I need to add month everytime so the NextMonth column would be 10-27-2022 at the first 18k and then 11-27-2022 at the second 18k.  I could not figure out how to do that so I thought maybe I could add an index every time NextMonth is not empty.  Anyone have any ideas??

MultiRow 

Included sample data with desired output.  Basically in the output tab, every time the running total is 18k or more, add 1 month to the Minimum date.  So in this data set, the next month would range from 9/27/2022 - 12/27/2022

[binuacs]

@oneillp111 Can you provide some sample data and expected output

[IraWatt]

Hey @oneillp111,

Here's one example of how to do this:

[binuacs]

@oneillp111 Another way of doing this with the formula tool

[oneillp111]

I added a sample set with output tab

[oneillp111]

@binuacs thanks for this but this would only chnage the date to 10/27.  I need to increment everything the running total hit 18k.  So it would go all the way to 12/27/2022.

[IraWatt]

Hey @oneillp111 

I've updated my workflow with your example data

let me know if there are any issues

[binuacs]

@oneillp111 attaching the updated workflow 

[oneillp111 · Accepted solution]

Solved my issue by adding a Record ID and Tile on Unique values, utilizing the Tile Sequence number as the months to add to Minimum ship date.