Week numbers

booiboa · Apr 8th, 2002, 04:34 AM

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 · Apr 8th, 2002, 04:42 AM

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 · Apr 8th, 2002, 05:31 AM

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 · Apr 8th, 2002, 05:38 AM

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 · Apr 8th, 2002, 08:27 AM

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. · Apr 8th, 2002, 09:12 AM

Quote:

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 · Apr 8th, 2002, 09:52 AM

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. · Apr 8th, 2002, 09:55 AM

Quote:

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 · Apr 8th, 2002, 10:08 AM

Thanks!

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 04:34 AM	#1
booiboa New Member Join Date: Apr 2002 Posts: 25	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 ///

Apr 8th, 2002, 04:42 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Boo I am not sure I understand your table layout or where this "Same cell" is but have you tried the SUMIF function?

Apr 8th, 2002, 05:31 AM	#3
booiboa New Member Join Date: Apr 2002 Posts: 25	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 //

Apr 8th, 2002, 05:38 AM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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 ]

Apr 8th, 2002, 08:27 AM	#5
booiboa New Member Join Date: Apr 2002 Posts: 25	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 //

Apr 8th, 2002, 09:52 AM	#7
booiboa New Member Join Date: Apr 2002 Posts: 25	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 //

Apr 8th, 2002, 10:08 AM	#9
booiboa New Member Join Date: Apr 2002 Posts: 25	Thanks! Now I see... ;D // Boo //