WEEKNUM

  • Thread starter Thread starter Mark Maiden
  • Start date Start date
M

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
 
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 *
 
Dear Rob
Yeh! That did the job. Now I can enter Week Numbers again
[I added Analysis Toolpak]

Many thanks

Mark
 
Back
Top