Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weeknum function help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weeknum function | Excel Worksheet Functions | |||
WEEKNUM Function | Excel Worksheet Functions | |||
Weeknum function | Excel Discussion (Misc queries) | |||
Weeknum Function | Excel Worksheet Functions | |||
WeekNUM Function | Excel Worksheet Functions |