Convert values cell text to Date

Learn Academy Feedback
1

Please how i can convert a text cell to date and compare it with date today . then if the date in the excel is distint as today y edit it with value today.
Thanks

2

You can use read range to read the data from excel. Use for each row activity to loop through every row and row(“Column Name”).tostring will give you the column value. Convert it to date and compare that with today’s date as DateTime.Compare(excelDate, todayDate). If the result of this is ‘0’, then both date’s are same. Update the datatable cell value as dtExcelData.Rows(dtExcelData.Rows.IndexOf(row))(“Column Name”) = todayDate.tostring

The alternative is write a Macro in excel and execute the macro using UiPath activity.