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?