# Return Month from fiscal date range

#### sdeleon

##### New Member
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>

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Weazel

##### Well-known Member
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
CellFormula
B14=LOOKUP(A14,B1:B12,A1:A12)

<tbody>
</tbody>

<tbody>
</tbody>

#### Guru008

##### Board Regular
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

##### MrExcel MVP
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

##### New Member
Weazel, THANK YOU!!!!!

you're welcome

Replies
2
Views
86
Replies
1
Views
381
Replies
2
Views
49
Replies
2
Views
125
Replies
4
Views
145

Threads
1,191,032
Messages
5,984,247
Members
439,879
Latest member
KingGoulash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back