(Question) How to create a sequence if data is on xx-yy basis

[Luqman]

Hi

If i have this data

Criteria       Days    Month  Year
Withdrawal 22-31   8          2023
Redemption 1-15    9          2023
Withdrawal 16-30    9          2023

I want "Days" to be individual data of 22,23,and so on

The data at the end should look like this (after formula [days]+"/"+[Month]+"/"+[Year])

Criteria        Date
Withdrawal 22/08/2023
Withdrawal 23/08/2023
Withdrawal 24/08/2023
Withdrawal 25/08/2023
Withdrawal 31/08/2023
Redemption 01/09/2023

Really appreciate the assistance

[JamesCharnley · Accepted solution]

Hi @Luqman 

You can use Generate Rows to scaffold all rows between a start and and end number, so you can use that tool in conjunction with a couple of formulas to get the date in the desired format after creating your dates.

[binu_acs · Accepted solution]

@Luqman