The problem is with WEEKNUM()
From Help:
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
Tools Add-Ins... Analysis Toolpak (check box)