Weeknum function help

[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

 

[Mike H]

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.