Counting no. of Specific Text in between dates

[Kookai]

Hi Guys,

Am here again... asking help...

How can i count no. of occurence of specific text in between dates, as i want to generate a report on weekly basis.

Sheet 1 (Request)

C1 - date received
I1 - Status (Awaiting Response, Cancelled, Released)
AD - Review Status (Complete, Under Study, Pending)

Sheet 2 (Report)

U1 - Date (weekly Start of dec 30, 2010 +7)
V1 - Released
W1 - Under Study
X1 - Pending
Y1 - awaiting response
z1- Cancelled

With, V1 i want to find out how many Released text in I1 within Dec 30 till Jan 4.

W1 how many under study text in AD within Dec 30 til Jan 4

and so on and so on.

Ur help is much appreciated.

 

[GlennUK]

You say that want to report weekly, but you show Dec 30 2010 till Jan 4 as a time period ... this isn't a week. And why start on Dec 30, a Thursday?

 

[Kookai]

Oh sorry! its meant to be January 6... In Middle East, the start of work is sunday and ends on thursday that is why...

thank

 

[GlennUK]

Oh sorry! its meant to be January 6... In Middle East, the start of work is sunday and ends on thursday that is why...

thank

So, shouldn't you be starting on Dec 31 2010, the day after the Thursday? Or any other day before Monday. Can grouping in PivotTables do what you want? ( group by day, 7 day, starting on a Friday or Saturday or Sunday date )

 

[Kookai]

Hi glen,

thank You i havent got experience with Pivot Table but will try.