WeekNum error

Topic

New Reply

Hi, I’m using the following formula in excel 2002 but get a ?Name error.

=WEEKNUM(TODAY())

I’m not sure what is wrong. I originally tried it as

=WEEKNUM(G1)

in order to get the week number for a specific date but that gave me the same error.

Thanks,
Leesha

Reply | Quote

Replies

Hi Leesha,

In order to use the WEEKNUM function, you must activate the Analysis ToolPak add-in:
– Select Tools | Add-Ins…
– Tick the check box for Analysis ToolPak.
– Click OK.

If you distribute the workbook to other users, they will have to do the same (unless they use Excel 2007 or later; Analysis ToolPak is built into Excel itself there).

Reply | Quote

Thank you so much! I found the actual WeekNum forumla while doing a search of the lounge and couldn’t for the life of me figure out why it wasn’t working. You saved me many hours, as always.

Thanks!
Leesha

Reply | Quote

The WEEKNUM function requires the Analysis Toolpak add-in to be loaded.Choose Tools/Add-ins from the Excel menu and put a check mark beside the entry called Analysis Toolpak (not Analysis Toolpak – VBA). If you don’t see this entry you’ll need to install it using your original installation disks.

Reply | Quote

Hi Leesha,

Note that the WEEKNUM function is wrong for ISO week numbers. If you’re in the US you’re fine.

Reply | Quote

in Europe You can use (Date in A1)

=TRUNC((A1-DATE(YEAR(A1+3-MOD(A1-2;7));1;MOD(A1-2;7)-9))/7)

regards,
stef

Reply | Quote