I have two columns StartDate and Endate the value of the columns is 'datetime'
EndDate=[ '05-Aug-2020 00:00:00''05-Aug-2020 00:00:00''07-Aug-2020 00:00:00''07-Aug-2020 00:00:00''07-Aug-2020 00:00:00''01-Aug-2020 00:00:00']Start Date= ['29-Jul-2020 00:00:00''29-Jul-2020 00:00:00''31-Jul-2020 00:00:00''31-Jul-2020 00:00:00''02-Aug-2020 00:00:00''01-Aug-2020 00:00:00''02-Aug-2020 00:00:00''29-Jul-2020 00:00:00''29-Jul-2020 00:00:00']
I would like to calculate the number of days per row in the column.
Best Answer