https://community.blueprism.com/t5/Product-Forum/HOW-TO-MATCH-TODAY-S-DATE/m-p/46851#M2740 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:&nbsp;=INDEX(B:B,MATCH(TODAY(),C:C,0))<BR /><BR />------------------------------<BR />Nicholas Zejdlik<BR />RPA Developer<BR />------------------------------<BR /> Thu, 07 May 2020 15:45:00 GMT NicholasZejdlik 2020-05-07T15:45:00Z https://community.blueprism.com/t5/Product-Forum/HOW-TO-MATCH-TODAY-S-DATE/m-p/46850#M2739 Hi All,<BR />i want to match today's date in xl sheet and select a cell in another column .<BR /><BR />compare<STRONG> Date</STRONG> from date column and to get&nbsp; today's <STRONG>Dp voyage</STRONG> number from <STRONG>Dp Voyage</STRONG> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="29928.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/30058iDAADC9B082A2E755/image-size/large?v=v2&amp;px=999" role="button" title="29928.png" alt="29928.png" /></span></DIV><BR /><BR />------------------------------<BR />NAVEEN KUMAR<BR /><BR />------------------------------<BR /> Wed, 29 Apr 2020 02:40:00 GMT https://community.blueprism.com/t5/Product-Forum/HOW-TO-MATCH-TODAY-S-DATE/m-p/46850#M2739 NAVEENKUMAR3 2020-04-29T02:40:00Z https://community.blueprism.com/t5/Product-Forum/HOW-TO-MATCH-TODAY-S-DATE/m-p/46851#M2740 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:&nbsp;=INDEX(B:B,MATCH(TODAY(),C:C,0))<BR /><BR />------------------------------<BR />Nicholas Zejdlik<BR />RPA Developer<BR />------------------------------<BR /> Thu, 07 May 2020 15:45:00 GMT https://community.blueprism.com/t5/Product-Forum/HOW-TO-MATCH-TODAY-S-DATE/m-p/46851#M2740 NicholasZejdlik 2020-05-07T15:45:00Z