consecutive weeks worked

**kossdust** · 03-09-2007, 10:56 AM

I am working on a spreadsheet that keeps track of hours worked each day and then it totals it by week and by month.

I have it setup that column A is the date, column B is the time in, column c is for break, column D is time out, and column E is the total. At the end of each week I do a total and a simple if that does consecutive weeks worked at the end of each week, but what I would really like it at the top to have a current consecutive weeks worked at the top.

I thought that it could be done by just comparing the actual date in the range of column a then point to that weeks Consecutive weeks calculation but i have failed.

**oldchippy** · 03-09-2007, 11:14 AM

Hello there,

It’s not exactly clear what you are trying to achieve from the information given. But if you can provide a small zipped sample of your data, then hopefully a solution can be found

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this to your post.

**kossdust** · 03-09-2007, 11:45 AM

ok I posted a sample of what I have. The red at the Top I want to be current consecutive weeks worked. Basiacilly need it to mirror the yellow total for the current week

**daddylonglegs** · 03-11-2007, 05:53 PM

Try this formula

=INDEX(C:C,MATCH(MAX(A:A),A:A,0)+1)

**kossdust** · 03-15-2007, 12:17 PM

Thanks for your help but the formula you gave me didn't work .. it kept giving 0

Any other ideas?

**daddylonglegs** · 03-15-2007, 02:31 PM

When I paste that formula into cell B3 in the spreadsheet you attached I get 1, which I presume is the answer you want but it may depend how you add data, do you add a day at a time or the whole week?

If it's the former then perhaps try this formula

=LOOKUP(2,1/(B4:B1000="CWW"),C4:C1000)

**kossdust** · 03-21-2007, 05:00 PM

Originally Posted by daddylonglegs

Try this formula

=INDEX(C:C,MATCH(MAX(A:A),A:A,0)+1)

Ok the problem with this formula is it just looks at the very last week. I really need it to look at the current week. Does that make since?

Originally Posted by daddylonglegs

Try this formula

=LOOKUP(2,1/(B4:B1000="CWW"),C4:C1000)

This also suffers from the same problem of only looking at the last week. This is why I was getting a 0 in the forumla b/c the spreadsheet goes until like November and I was looking for current and it was giving me what has not been put in at the end of the spreadsheet

thanks for your help daddylonglegs

consecutive weeks worked

LinkBack

Thread Tools

Rate This Thread

Display

consecutive weeks worked

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions