I have an excel list with two dates that i would like to compare.
I want to create a new column “Posting date in the previous month”. The bot should then check for each line whether the “posting date” is in the month before the “goods issue date”. If this is the case, a yes should appear in the cell in the column “posting date in the previous month” and the cell should turn red. Otherwise a no should appear and the cell should be colored green.
What is the best way to build this in uipath?
Any help would be great