Need Help

Daboyz1971 · Apr 24th, 2002, 01:26 PM

Need to keep track of a value in a cell from week to week.

ex.
cell a1 = 1 for the first week then cell a1 = 2 for the second week then cell a1 = 3 for the third week ect....

on another sheet i need to know that during week 1 cell a1 was = 1 and week 2 cell a1 was = 2 ect... any help would be greatly appreciated.

eliW · Apr 25th, 2002, 05:10 AM

Quote:

cell a1 = 1 for the first week then cell a1 = 2 for the second week then cell a1 = 3 for the third week ect....

What do you need? 52 weeks in a year OR 4 week cycle?

[ This Message was edited by: eliW on 2002-04-25 04:12 ]

Daboyz1971 · Apr 25th, 2002, 08:04 AM

52 weeks

eliW · Apr 25th, 2002, 11:47 AM

Quote:

On 2002-04-25 07:04, Daboyz1971 wrote:
52 weeks

Here is a formula which will give you the cuurent week from the year begining:

=INT(DAYS360("01/01/2002",TODAY(),FALSE)/7)+1

I do not have a full answer to your question but at least it is a start.
Eli

[ This Message was edited by: eliW on 2002-04-25 10:48 ]

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

Apr 24th, 2002, 01:26 PM	#1
Daboyz1971 New Member Join Date: Mar 2002 Posts: 24	Need to keep track of a value in a cell from week to week. ex. cell a1 = 1 for the first week then cell a1 = 2 for the second week then cell a1 = 3 for the third week ect.... on another sheet i need to know that during week 1 cell a1 was = 1 and week 2 cell a1 was = 2 ect... any help would be greatly appreciated.

Apr 25th, 2002, 08:04 AM	#3
Daboyz1971 New Member Join Date: Mar 2002 Posts: 24	52 weeks