Fiscal Week Formula
I am looking for a formula to calculate the Fiscal Week duration of a project.
The formula should be in the highlighted cells and should return the Fiscal weeks that have a value in the FW column.
I am using this formula, but it returns Invalid Data Type
=WEEKNUMBER([FW 37]1:[FW 52]1, 1, 0)