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

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

"Franz Verga" wrote in message
...

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!