Hi, I have a dataset that I want to split based on 2 date columns. In this new column, the date for the intervening months should become the last day of that month Example; Start date Enddate 03Jan2022 05may2022 Result: Start date Enddate NewColumn 03Jan2022 05may2022 03jan2022 03Jan2022 05may2022 28feb2022 03Jan2022 05may2022 31mar2022 03Jan2022 05may2022 30apr2022 03Jan2022 05may2022 05may2022 Thanks for your help!
... View more