Converting Excel Formulas to UiPath Standard

Good day Friends - quick one,I have a formula I am trying to pass into an excel report to convert Months into Numbers.

=MONTH(DATEVALUE(B3&"1")) - this seems to work with Excel but when I input this in Studio - I keep getting an error - anyone experienced before.

Many thanks

@odure

Did you add it like this

"=MONTH(DATEVALUE(B3&""1""))"

This is how you add the formula using write formula activity

cheers

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.