Week numbers

[booiboa]

Hi there,

We use excel workbooks to report our time in our project. Each person updates his excelfile every friday. In this workbook there are columns for every week and they are numbered 1-52 as the 52 weeks of the year.
Now to my question:
How can I get the total hours of the current week in the same cell, without the previous weeks time included, when that is different column every week?

Thanks guys,
/// Boo Engstrand ///

 

[Dave Hawley]

Hi Boo


I am not sure I understand your table layout or where this "Same cell" is but have you tried the SUMIF function?

 

[booiboa]

No, I have not.
I guess that could work, but only if I can get "todays date" and place that in a week number. Is there a function in excel that keeps track of the week numbering?

Thanks for your help!
// Boo //

 

[Derek]

Hi there
In Excel 2000 there is a function called weeknum that will give you the week number. So you can use the formula =today() in one cell and have the formula =weeknum refer to it to give the number of the week.
regards
Derek
This message was edited by Derek on 2002-04-08 04:41
This message was edited by Derek on 2002-04-08 04:42

 

[booiboa]

Hi Derek,

Sounds like a great function. just what I need. Too bad that I can't change from Excel 97 to Excel 2000. Any ideas to handle that?
// Boo //

 

[Mark W.]

On 2002-04-08 07:27, booiboa wrote:
Hi Derek,

Sounds like a great function. just what I need. Too bad that I can't change from Excel 97 to Excel 2000. Any ideas to handle that?
// Boo //

The WEEKNUM worksheet function can be used in Excel 97 once the Analysis ToolPak add-in has been added. See the Help Index topic for "Install and use the Analysis ToolPak".

 

[booiboa]

OK, thanks!

How do I format the cell with this formula?
When I put =WEEKNUM in the cell the output is:
-640155557

I sort of expected something like w.12 but I could not find any good formatting on it.
// Boo //

 

[Mark W.]

On 2002-04-08 08:52, booiboa wrote:
OK, thanks!

How do I format the cell with this formula?
When I put =WEEKNUM in the cell the output is:
-640155557

I sort of expected something like w.12 but I could not find any good formatting on it.
// Boo //

See the Excel Help topic for WEEKNUM worksheet function.

 

[booiboa]

Thanks!

Now I see... ;D
// Boo //