Problem with write cell excel formula


I want to get the weeknumbers from an excel column with dates.
For this I have a Write cell activity in a For each excel row with the formula: “=Weeknumber(A1)”

The robot writes this as “=@week number(a1)”, excel displays this as #name.
Only when I click on the cell is the formula recognized and calculated.

What do I need to do to run the formula immediately?

Hi @janwillem1
Try using the Excel not the Workbook activities

Hi @janwillem1 ,

Try to use below code and let me know if you face any issue.

WriteFormula.xaml (6.1 KB)

Make sure below package is installed