Formula: Weeknum() in Excel 2003

In Excel 2003 the Weeknum() formula will only be activated when the Analysis toolpack is installed. Go to Options -> Addin -> select Analysis Toolpack -> OK. The formula should work now.

Furthermore if you use the Dutch version of Excel, the formula should be typed in English instead of the Dutch [Weeknummer() ].

Xcelsius translates all formulas to English anyway when converting to flash scripting.

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Excel and tagged , , . Bookmark the permalink.

One Comment to Formula: Weeknum() in Excel 2003

  1. Land Kites says:

    Just to let you know your site appears a little bit unusual on Firefox on my pc using Linux .