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
Solved! Go to 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.