Weeknum function help
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
|