Prev: Text to Number format
Next: How do I change the format to allow a zero as a first digit?
From: Cam on 2 Apr 2010 10:21
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
From: Mike H on 2 Apr 2010 10:29
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.


"Cam" wrote:

> 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
 | 
Pages: 1
Prev: Text to Number format
Next: How do I change the format to allow a zero as a first digit?