WRITE FORMULAS IN EXCEL

[johan.montalvo]

Hi guys, i hope you’re well.

In this moment i want to write the formula “=HOY()” in a cell, but when i use the follow step in Ui path and write the formula, in Excel appears as in the next capture:

What can i do to the formule appears in the correct way in excel? (without the error #¿NOMBRE?)

Srry for my english, im learning…

Thanks a lot

[Anil_G (Anil Gorthi)]

@johan.montalvo

Are you using excel activities or workbook activities?

You need to use excel activities only

Cheers

[johan.montalvo]

Look @Anil_G

[Yoichi]

Hi,

Can you try to use =TODAY() instead of =HOY()? It will be automatically converted to HOY().

Regards,

[vrdabberu (Varunraj Dabberu)]

Hi @johan.montalvo

Can you try using below formula in Write Cell:

"=TODAY()"

Check if your Excel is in Spanish, then “=HOY()” should be the correct formula. If your Excel is in English, then you should use “=TODAY()”. If you are using an older version of Excel, some functions might not be available. Check if your version of Excel supports the “=TODAY()” function. Ensure that the cell where you are writing the formula is formatted as General or Date, depending on your expected result.

Regards

[johan.montalvo]

This works. Thanks @Yoichi !!

[Anil_G (Anil Gorthi)]

@johan.montalvo

If you just remove the string.Format() then also it would work

Cheers