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 |
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 |
All times are GMT +1. The time now is 06:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com