weeknum gone ??

[KrunoG]

Hi!

I had weeknum function in one of my documents but it doesn't work anymore.
It's not even in a list of functions. :-0
How do I fix this, to get my week numbers back?

BR

Kruno

 

[Franz Verga]

Nel post *KrunoG* ha scritto:

Hi!

I had weeknum function in one of my documents but it doesn't work
anymore. It's not even in a list of functions. :-0
How do I fix this, to get my week numbers back?

BR

Kruno

Hi Kruno,

The WEEKNUM function belongs to the Analysis ToolPak (ATP) add-in, so you
have to install it.

Menu Tools, Add-ins, flag Analysis ToolPak and also Analysis ToolPak - VBA.
click OK. Now your WEEKNUM is back.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[KrunoG]

Hi Kruno,

The WEEKNUM function belongs to the Analysis ToolPak (ATP) add-in, so you
have to install it.

Menu Tools, Add-ins, flag Analysis ToolPak and also Analysis ToolPak - VBA.
click OK. Now your WEEKNUM is back.

Unbelievably how frustrating this "little" things can be. I had checked ATP
but not the one with VBA.

Thank you!