Reading row of Dates but there is a formula in it

Hi everyone,

So I am trying to read a row of dates but they seem to have a formula and everytime I write line to string it converts to the general format in excel (in a way). image How can I go about this? Should I copy and paste as values first?

Hi @ktanli,

Just use a vbscript by using the invoke vba activity and it will be done in seconds.
Let me know if you are not able to achieve that and want a xaml.

Cheers,
Shikhar