Excel automation11

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)



can you share your excel file with example data?


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


I didnt understand

Try this, It will get you the last course date, irrespective of dates count.

BlankProcess.zip (18.8 KB)