Hello @kashif.ansari417
I hope while reading the excel the formula is not getting updated for the todays date and thats why you are getting the yesterday’s date.
So you have to either refresh the excel using vb script or you can open the excel using Use Excel file activity. I hope that can solve your issue.
Thanks