Extracting info based on month. Please Help

[LibraJB]

Hi guys,

I tried many times. I have a concept but unable to come up with an excel formula. Please help me out..

Column start from A to Q
Row start from 1 to 5

Table 1

Fruits

Lead Time

In Stock

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jun2

Jul2

Aug2

Sep2

Oct2

Nov2

Dec2

Apple

14

50

200

100

100

200

100

100

5/18/2016

6/17/2016

7/18/2016

8/18/2016

9/17/2016

10/18/2016

11/17/2016

Orange

31

50

200

100

100

200

100

100

5/1/2016

5/31/2016

7/1/2016

8/1/2016

8/31/2016

10/1/2016

10/31/2016

Banana

62

50

200

100

100

200

100

100

3/31/2016

4/30/2016

5/31/2016

7/1/2016

7/31/2016

8/31/2016

9/30/2016

Strawberry

93

50

200

100

100

200

100

100

2/29/2016

3/30/2016

4/30/2016

5/31/2016

6/30/2016

7/31/2016

8/30/2016

<tbody>
</tbody>

Example:
In Jul, I need to order 200 Apples, which have to arrive on 7/1/2016. The lead time is 14 days in advanced to make an order to my agent supplier. I calculated the monthly lead time using formula: =DATE(2016,7,1)-B2 in L2. (This apply to others respectively)

Because of the lead time, I have to purchase in advance, I would like make a formula that list all purchases that should be make on that particular month.

Lets say for Jul (Some values are repeated, example) the formula in table 2 in the cell are capable to extract info from table 1:

Table 2

7/1/2016	Orange	100	Aug2
7/1/2016	Banana	100	Sep2
7/18/2016	Apple	100	Aug2
7/31/2016	Banana	200	Oct2
7/31/2016	Strawberry	100	Nov2

<tbody>
</tbody>

Do anyone have any idea for cell formula in table 2?

Then once have the formula for table 2, similar formula can be use for table 3 for August, table 4 for September and so on..

Please help~

 

[ProfessorPorcupine]

Maybe try using the Month function, like below:
=IF(MONTH(L2)=7,"Order","")

You could also have the month at the top of the columns, then just copy the same formula throughout (which reduces the chance for errors), like this:
=IF(MONTH(L2)=L$1,"Order","")