Using the ,21 (ISO) option when determining WEEKNUMBER - Sheet displays ok, Report doesn't
When using this formula to return a week number
=IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row, 21))
the correct week number value displays accurately in the sheet which is good.
However, the Report fails to display the column value and displays
#INCORRECT ARGUMENT SET
Removing the ,21 parameter and using this formula
=IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row))
ensures that the formula value displays ok on the report but leads to incorrect Week Numbers in both the sheet and report.
Has anyone found a workaround for this to enable the correct ISO Week number to display on the report?