Date format and weeknum formel
 

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

Date format and weeknum formel
 

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

Date format and weeknum formel
 

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

Date format and weeknum formel
 

The OP says the ATP is installed...
--
Brevity is the soul of wit.


"Ron de Bruin" wrote:

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

Date format and weeknum formel
 

Analysis Toolkpak already checked

"Ron de Bruin" wrote:

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

Date format and weeknum formel
 

Its set to Automatic, but it doesn`t do any updates other then automatic
refresh when started. I clicked the "update" now button but nothing happend..

"Dave F" wrote:

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

Date format and weeknum formel
 

Do you have a English Excel version ??
You use ;

See this page for a normal function (no ATP needed)
http://www.rondebruin.nl/weeknumber.htm




--

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


"svemor" wrote in message ...
Analysis Toolkpak already checked

"Ron de Bruin" wrote:

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

Date format and weeknum formel
 

If you reenter that value and the formula works, then I'm betting that the
original value isn't really a date--I'm thinking that it's a string that looks
like a date.

If the dates are all in one column, you can try to convert them by using:

Select the range (single column)
data|text to columns

and choose mdy (or dmy???) and finish up.

Then see if the formula updates ok.

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

--

Dave Peterson

Date format and weeknum formel
 

Thanks. I think thats the problem, I`m gonna try it tomorrow at work.
I will let you know if it works.

"Dave Peterson" wrote:

If you reenter that value and the formula works, then I'm betting that the
original value isn't really a date--I'm thinking that it's a string that looks
like a date.

If the dates are all in one column, you can try to convert them by using:

Select the range (single column)
data|text to columns

and choose mdy (or dmy???) and finish up.

Then see if the formula updates ok.

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

--

Dave Peterson