weeknum function returns name error

[Unison Mike]

I am trying to use the weeknum function in excel 2003. However I am getting a
#NAME error, I have followed the helpfile instructions to make sute the
analysis toolpak is checked in the add-in menu, but this doesn`t seem to make
any difference. I can select the weeknum function from the formula wizard but
it still doesn't work.

[Bob Phillips]

When the analysis toolpak is not installed, I get a #VALUE error (oddly!).
Are you sure that the references within the brackets are correct, a valid
cell, or TGODAY()?

--
HTH

Bob Phillips

"Unison Mike" <Unison [email protected]> wrote in message
news:[email protected]...
> I am trying to use the weeknum function in excel 2003. However I am
getting a
> #NAME error, I have followed the helpfile instructions to make sute the
> analysis toolpak is checked in the add-in menu, but this doesn`t seem to
make
> any difference. I can select the weeknum function from the formula wizard
but
> it still doesn't work.

[Peo Sjoblom]

WEEKNUM is part of the Analysis ToolPak add-in, keep the CD handy and do
tools>add-ins, check ATP and follow the directions. If it is not working try
to uninstall it by uncheck it and then install it again, if that does not
work, uncheck it, then reinstall it with the CD by adding it again. (check
run from this computer or something similar under Excel installation, note
that you should not install excel/office again, just add something)

--
Regards,

Peo Sjoblom


"Unison Mike" <Unison [email protected]> wrote in message
news:[email protected]...
>I am trying to use the weeknum function in excel 2003. However I am getting
>a
> #NAME error, I have followed the helpfile instructions to make sute the
> analysis toolpak is checked in the add-in menu, but this doesn`t seem to
> make
> any difference. I can select the weeknum function from the formula wizard
> but
> it still doesn't work.

[Unison Mike]

Seem to have got it to work - for some bizarre reason I had to start a new
workbook, use the formula in there, it would then work in the original
document.

Unfortunately it turns out that the weeknum function doesn't return iso
standard week numbers anyway so not much use.

Fortunately the following site had the answer:

http://cpearson.com/excel/weeknum.htm

Thanks anyway.

Mike



"Unison Mike" wrote:

> I am trying to use the weeknum function in excel 2003. However I am getting a
> #NAME error, I have followed the helpfile instructions to make sute the
> analysis toolpak is checked in the add-in menu, but this doesn`t seem to make
> any difference. I can select the weeknum function from the formula wizard but
> it still doesn't work.

[Ron de Bruin]

Hi Mike

See the formulas that don't need the ATP Add-in on this page
http://www.rondebruin.nl/weeknumber.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Unison Mike" <Unison [email protected]> wrote in message news:[email protected]...
> Seem to have got it to work - for some bizarre reason I had to start a new
> workbook, use the formula in there, it would then work in the original
> document.
>
> Unfortunately it turns out that the weeknum function doesn't return iso
> standard week numbers anyway so not much use.
>
> Fortunately the following site had the answer:
>
> http://cpearson.com/excel/weeknum.htm
>
> Thanks anyway.
>
> Mike
>
>
>
> "Unison Mike" wrote:
>
>> I am trying to use the weeknum function in excel 2003. However I am getting a
>> #NAME error, I have followed the helpfile instructions to make sute the
>> analysis toolpak is checked in the add-in menu, but this doesn`t seem to make
>> any difference. I can select the weeknum function from the formula wizard but
>> it still doesn't work.