Thanks:  0
Likes:  0

# Thread: Need Help

1. 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.

2. 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 ]

3. 52 weeks

4. 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 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•