Hi Team,
I want extract the date 04-Nov-2022 from the given file. help me to get the date… wrt “Course Date” always it should get the last row entry.(sometimes it will have 2 or 3 dates)
TIA
Hi Team,
I want extract the date 04-Nov-2022 from the given file. help me to get the date… wrt “Course Date” always it should get the last row entry.(sometimes it will have 2 or 3 dates)
TIA
test.xlsx (20.9 KB)
just a quick way based on the requirement that could be 2 o 3 dates, you can get those 3 cells (C5, C6, C7) using the read cell activity, validate and just work with the not empty values, and just based on that get the last cell not empty value
Regards
I didnt understand
Try this, It will get you the last course date, irrespective of dates count.
BlankProcess.zip (18.8 KB)