How to read excel cell having path value along with the date

Help Activities
, , ,
1

Hi,
I want to read excel cell which has path and the date both in same cell that date is coming from some other cell in which formula today() is applied
When I used Readcell activity path value comes right but for date it give value as dd-Sep-yyyy

2

Hi! The today() value from excel is the exact value of the current day and not the today() date when the Excel was created, right?

If it is like that, you don’t really need to read the date from the Excel as you can get it in any format you want from Studio directly. You can use System.DateTime.Today.ToString(“{add your own format}”).
For example:
System.DateTime.Today.ToString(“dd-mm-yyyy”) will get you 14-09-2023