Excel automation11

[MEGHA_cs]

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

[fernando_zuluaga]

HI @MEGHA_cs

can you share your excel file with example data?

Regards!

[MEGHA_cs]

test.xlsx (20.9 KB)

[fernando_zuluaga]

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

[MEGHA_cs]

I didnt understand

[Manzar.Ali (Manzar Ali Sayyed)]

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

BlankProcess.zip (18.8 KB)