Selecting rows if a date falls within a date range

[walkercanopy]

Hi,

I am two excel sheets -- one with monthly goal by market and another one with weekly sales number by market. In the weekly sales sheet I need to determine what percentage of goal is met.

Here is an example: Arizona Jan (first 4 weeks) goal is $300K. Sales in Arizona on week1 was $30K, so percentage of goal met was 10%; on week2 sale was $85K (cumulative $115K), so percentage met was ~38% and so on.

I need to get the correct row from Goal sheet to calculate the percentage. The challenge is that goals are by month and sales summary are by week. Here are logical steps:
1. Match the market first, which will give me multiple monthly goals.
2. Check the record where the week (date) falls in between the monthly start and end dates.
3. Get the Goal data and calculate the percentage using the cumulative sales.

How do I do the step 1 and 2?

Here is the Goal sheet:

Market	StartDt	EndDt	Goal
AZ	1-Jan-17	28-Jan-17	$300,000
AZ	29-Jan-17	25-Feb-17	$275,000
AZ	26-Feb-17	25-Mar-17	$308,000
GA	1-Jan-17	28-Jan-17	$280,000
GA	29-Jan-17	25-Feb-17	$275,000
GA	26-Feb-17	25-Mar-17	$325,000
KY	1-Jan-17	28-Jan-17	$180,000
KY	29-Jan-17	25-Feb-17	$165,000
KY	26-Feb-17	25-Mar-17	$175,000
NY	1-Jan-17	28-Jan-17	$520,000
NY	29-Jan-17	25-Feb-17	$540,000
NY	26-Feb-17	25-Mar-17	$575,000

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

Here is the Weekly sales sheet:

Market	WeekStartDt	Sales	Cummulative Market Sales	% of Goal Met
AZ	1-Jan-17	$30,000	$30,000
AZ	8-Jan-17	$85,000	$115,000
AZ	15-Jan-17	$150,000	$265,000
GA	1-Jan-17	$20,000	$20,000
GA	8-Jan-17	$75,000	$95,000
GA	15-Jan-17	$170,000	$265,000
KY	1-Jan-17	$35,000	$35,000
KY	8-Jan-17	$30,000	$65,000
KY	15-Jan-17	$190,000	$255,000
NY	1-Jan-17	$60,000	$60,000
NY	8-Jan-17	$135,000	$195,000
NY	15-Jan-17	$250,000	$445,000

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

 

[walkercanopy]

Sorry for the grammatical mistakes in my post!!

Also, I am new to board and don't know how to attach a sample file. I looked at options available, but couldn't find any.