Calculate vales in a date range

[#1]

How can we show values for a date range,

My date range here is 2 weeks  alternate Wednesday(07-09-2014, 07-23-2014), and I need to count number of documents submitted in that date range.

Output:

Project Name	Prjt Manager	Dates : 7/23/2014- 7/10/2014	7/9/2014-6/26/2014	6/25/2014-6/12/2014	6/11/2014-5/28/2014
Prj 1	Sam	5	3	2	1
Prj 2	Pam	1	2	1	2
Prj 3	Dan	2	4	5	3
Prj 4	Don	1	0	4	5

Script

Calendar:

Load

Calendar_Dt;

  SQL Select Calendar_Dt,

Case When abs( year_week/2)<>floor( year_week/2) and DAY_ABBREVIATION='WED'
Then 1
ELSE 0
END as Flag
from DMN_CALENDAR
where CALENDAR_DT>=Sysdate - 365 and CALENDAR_DT<=Sysdate
and DAY_ABBREVIATION='WED' ;

Portfolio:

Load

Modified_Date as Calendar_Dt,

Project Name,

Prjt Manager,

Path

From

Portfolio.xlsx;