Perhaps your calculations are not set to automatic.

Tools--Options--Calculations-_Automatic

Dave
--
Brevity is the soul of wit.


"svemor" wrote:

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