Remove Suffix from Date column and repeat rows based on condition

[AnanditaShankar]

Hi , I want to remove " ET" or "CT" from my column A to D i.e all the columns having date with a suffix. Also if the diff between "From Date " and "To Date" is more than 1 day then I want the rows to repeat for that many times..  For eg : If the difference is 7 days then that row should repeat for 7 times . 

[binuacs · Accepted solution]

@AnanditaShankar One way of doing this with the Multi-Field formula

[AnanditaShankar]

Thanks binuacs. Also in the same workflow , if I want to increment the "From Date" to next date based on "DateDiff" , what could be done ? Please see desired output in below screenshot. Highlighted is the "From Date" column.

[binuacs · Accepted solution]

@AnanditaShankar use one more row generate tool to generate the expected result you mentioned above

[AnanditaShankar]

Thanks binuacs . This is helpful