I need some help with an automation.
I have an excel spreadsheet that has a date column, this column can contain any date value. eg. 1 Jan 2020, 13 March 2020, 25 December 2020 etc.
I prompt my users to input a date. Again this can be any date of the year.
The automation then needs to evaluate if the date entered is smaller than the date in the cell. When it finds a larger date it needs to return the row index from where I can calculate where to insert a new row (RowIndex - 1)
In my opinion Lookup Data Table is out because it is not an exact match.
I have tried Read Row but I dont seem to be using the IEnumerable object correctly
I assume I would have to use the IF logic but the math surrounding dates and where to do it has me stumped.
Appreciate the feedback.