WEEKNUM

[Mark Maiden]

My spreadsheet that was used on Windows 95 sucessfully
has a problem in Windows XP Professional with the WEEKNUM
function.

I get an error #NAME? instead of the week number. Its
been working for a few years now but not with Windows XP
Pro anymore.

Yours faithfully

Mark Maiden

 

[Rob Bovey]

Hi Mark,

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.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Mark Maiden]

Dear Rob
Yeh! That did the job. Now I can enter Week Numbers again
[I added Analysis Toolpak]

Many thanks

Mark