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.

Jan	1/3/16	1/30/16
Feb	1/31/16	2/27/16
Mar	2/28/16	4/2/16
Apr	4/3/16	4/30/16
May	5/1/16	5/28/16
Jun	5/29/16	7/2/16
Jul	7/3/16	7/30/16
Aug	7/31/16	8/27/16
Sep	8/28/16	10/1/16
Oct	10/2/16	10/29/16
Nov	10/30/16	11/26/16
Dec	11/27/16	12/31/16

<!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

 

[Weazel]

something like...

Excel 2016 (Windows) 32 bit

	A	B	C
1	Jan	1/3/2016	1/30/2016
2	Feb	1/31/2016	2/27/2016
3	Mar	2/28/2016	4/2/2016
4	Apr	4/3/2016	4/30/2016
5	May	5/1/2016	5/28/2016
6	Jun	5/29/2016	7/2/2016
7	Jul	7/3/2016	7/30/2016
8	Aug	7/31/2016	8/27/2016
9	Sep	8/28/2016	10/1/2016
10	Oct	10/2/2016	10/29/2016
11	Nov	10/30/2016	11/26/2016
12	Dec	11/27/2016	12/31/2016
13
14	3/15/2016	Mar

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B14 =LOOKUP(A14,B1:B12,A1:A12) <tbody> </tbody>

<tbody>
</tbody>

 

[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