Return Month from fiscal date range

[sdeleon]

I run my company on fiscal dates and have the ranges in date format. I need a formula to return the month based on the ranges I provide. Below is the table the has the month assigned to the fiscal date ranges.
If a cell reads 3/15/16 I need the output in a separate cell to read Mar.

[TABLE="width: 195"]
<!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 65"]Jan[/TD]
[TD="class: xl65, width: 65, align: right"]1/3/16[/TD]
[TD="class: xl65, width: 65, align: right"]1/30/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Feb[/TD]
[TD="class: xl65, align: right"]1/31/16[/TD]
[TD="class: xl65, align: right"]2/27/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Mar[/TD]
[TD="class: xl65, align: right"]2/28/16[/TD]
[TD="class: xl65, align: right"]4/2/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Apr[/TD]
[TD="class: xl65, align: right"]4/3/16[/TD]
[TD="class: xl65, align: right"]4/30/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]May[/TD]
[TD="class: xl65, align: right"]5/1/16[/TD]
[TD="class: xl65, align: right"]5/28/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Jun[/TD]
[TD="class: xl65, align: right"]5/29/16[/TD]
[TD="class: xl65, align: right"]7/2/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Jul[/TD]
[TD="class: xl65, align: right"]7/3/16[/TD]
[TD="class: xl65, align: right"]7/30/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Aug[/TD]
[TD="class: xl65, align: right"]7/31/16[/TD]
[TD="class: xl65, align: right"]8/27/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Sep[/TD]
[TD="class: xl65, align: right"]8/28/16[/TD]
[TD="class: xl65, align: right"]10/1/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Oct[/TD]
[TD="class: xl65, align: right"]10/2/16[/TD]
[TD="class: xl65, align: right"]10/29/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Nov[/TD]
[TD="class: xl65, align: right"]10/30/16[/TD]
[TD="class: xl65, align: right"]11/26/16[/TD]
[/TR]
[TR]
[TD="class: xl64"]Dec[/TD]
[TD="class: xl65, align: right"]11/27/16[/TD]
[TD="class: xl65, align: right"]12/31/16[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

 

[Weazel]

something like...

Excel 2016 (Windows) 32 bit[TABLE="class: grid, width: 200"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Jan[/TD]
[TD="align: right"]1/3/2016[/TD]
[TD="align: right"]1/30/2016[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Feb[/TD]
[TD="align: right"]1/31/2016[/TD]
[TD="align: right"]2/27/2016[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Mar[/TD]
[TD="align: right"]2/28/2016[/TD]
[TD="align: right"]4/2/2016[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Apr[/TD]
[TD="align: right"]4/3/2016[/TD]
[TD="align: right"]4/30/2016[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]May[/TD]
[TD="align: right"]5/1/2016[/TD]
[TD="align: right"]5/28/2016[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Jun[/TD]
[TD="align: right"]5/29/2016[/TD]
[TD="align: right"]7/2/2016[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Jul[/TD]
[TD="align: right"]7/3/2016[/TD]
[TD="align: right"]7/30/2016[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Aug[/TD]
[TD="align: right"]7/31/2016[/TD]
[TD="align: right"]8/27/2016[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Sep[/TD]
[TD="align: right"]8/28/2016[/TD]
[TD="align: right"]10/1/2016[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Oct[/TD]
[TD="align: right"]10/2/2016[/TD]
[TD="align: right"]10/29/2016[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Nov[/TD]
[TD="align: right"]10/30/2016[/TD]
[TD="align: right"]11/26/2016[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD]Dec[/TD]
[TD="align: right"]11/27/2016[/TD]
[TD="align: right"]12/31/2016[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]3/15/2016[/TD]
[TD]Mar[/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B14[/TH]
[TD="align: left"]=LOOKUP(A14,B1:B12,A1:A12)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Guru008]

Hi,

Try below formula in cell "D"

= TEXT(MAX(B1:C1),"mmm")

I am able to respond in real time to you until it is solved!

 

[Tetra201]

Assuming your lookup date is in cell E2, try the following formulas:

for the month's number =LOOKUP((E2-"2016-1-3")/7,{0,4,8,13,17,21,26,30,34,39,43,47,52},{1,2,3,4,5,6,7,8,9,10,11,12,#N/A})
for the month's 3-letter =TEXT(DATE(2016,LOOKUP((E22-"2016-1-3")/7,{0,4,8,13,17,21,26,30,34,39,43,47,52},{1,2,3,4,5,6,7,8,9,10,11,12,#N/A}),1),"mmm")

 

[sdeleon]

Weazel, THANK YOU!!!!!

 

[Weazel]

you're welcome