It just calculates the week number of the date cell. Add it to every row
that has a date.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LiveUser" wrote in message
...
Bob. Thank you for responding. I am unfamiliar with this formula. I put it
in, but didn't really understand it. Do you mind elborating on what this
formula does, how, and where it should be in relation to the other cells?

Thank you.

"Bob Phillips" wrote:

Just add a helper column with a formula of say

=WEEKNUM(A2)

and filter on this column


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"LiveUser" wrote in message
...
How would I filter this?
I want to filter by week and I want Undeted States and the Name to
show.

United States United States United States
Abraham Brandon Corey
4-Jan-08
11-Jan-08
18-Jan-08