Weeknum function help

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I am trying to show the current week and using this formula:
=WEEKNUM(TODAY())-1, someday it works, somday it doesn't (return "#NAME?").
Why is that?

Is there other alternative? Thanks
 
Hi,

The WEEKNIM function requires the analysis toolpak to be loaded in versions
priot to E2007 so I guess sometimes it's running on a machine where it isn't
loaded. To load it

Tools|Addins and check 'Analysis Toolpak'
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WEEKNUM function not working 4
Weeknum formula 2
weeknum function 1
Weeknum function issue 7
Weeknum Within a Range 5
Weeknum Issue 3
Weeknum(today()) gives wrong weeknummer 5
=WEEKNUM function 2

Back
Top