Calculate due date based on corporate entity law

4

@Rocky_Slaughter ,
to make it easier, you can create a table like mine and you create a column you fill out with the code snippet below. make sure the names do correspond. You are done in two minutes :wink:

Sequence(1,20).ForEach(Product(CurrentValue,thisRow.IntervalMonth).
WithName(intervals,

intervals.ForEach(
 Date(
thisRow.Date.Year(),
thisRow.Date.Month() + CurrentValue,
thisRow.Date.Day()))
      
    ) - ToDay()).WithName(outcome,
      
Today() + outcome.Filter(CurrentValue > 1).First())

Currentvalue is the item that is evaluated, we geneated a list with 20 currentvalues, 20 items.

Feel free to ask your questions, if any, Cheers, Christiaan