HOW TO MATCH TODAY'S DATE

[NAVEENKUMAR3]

Hi All,
i want to match today's date in xl sheet and select a cell in another column .

compare Date from date column and to get  today's Dp voyage number from Dp Voyage

------------------------------
NAVEEN KUMAR

------------------------------

[NicholasZejdlik]

If you load the worksheet as a collection in Blue Prism, then you'd just need to loop over each row until you find today's date (if that's not working right for you, post your Blue Prism stages). On the other hand, if you're looking for an Excel solution, this formula will pull the first DP Voyage number for today's date: =INDEX(B:B,MATCH(TODAY(),C:C,0))

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------