Weeknum is a ATP function

ToolsAdd-ins and check the Analysis Toolpak

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"svemor" wrote in message ...
Hi

I`ve got a couple of "nice" excel sheets at work, made by an ex-employe. Now
I have to make them work for 2007. The sheet has an auto update when started,
imports data fra a database.

This fomel =WEEKNUM(A1;2) returns #value!. A1 shows 11.01.2007, and should
have returned 2(as weeknumber 2). If I write the date again av 2007-01-11, it
shows 11.01.2007 and the weeknum formel shows 2.

What could be the problem? wrong time/date setup?

I have added the analysis toolpak.

/svemor