I have a date column in the excel which is in the format “02/07/2022 22:26:22”.
Currently i used the logic which adds 7 days for all the existing dates.
LOGIC : Date.Parse(datetime).AddDays(7).toString(“MM/dd/yyyy HH:mm:ss”)
datetime is the Variable.
But I want to add random 1 - 4 days for each row which consists of 950 records.