IF Functions for a table to find Fiscal Month

[michaxcore]

Hi, sorry about the title, I didn't really know how to word my problem.

I have cells with a date and in the cell next to it I would like to know what fiscal month that date falls under using the table below.

START	END	MONTH
12/28/2014	1/24/2015	JANUARY
1/25/2015	2/21/2015	FEBRUARY
2/22/2015	3/28/2015	MARCH
3/29/2015	4/25/2015	APRIL
4/26/2015	5/23/2015	MAY
5/24/2015	6/27/2015	JUNE
6/28/2015	7/25/2015	JULY
7/26/2015	8/22/2015	AUGUST
8/23/2015	9/26/2015	SEPTEMBER
9/27/2015	10/24/2015	OCTOBER
10/25/2015	11/21/2015	NOVEMBER
11/22/2015	12/26/2015	DECEMBER
12/27/2015	1/23/2015	JAN 2016

<tbody>
</tbody>

I am familiar with vlookup, index/match, and if statements but I am confused on how to write an if function to go thru that table and shoots back the month associated in the date range.

For Example:

3/12/2015	MARCH
4/26/2015	MAY
4/25/2015	APRIL

<tbody>
</tbody>

Thank you for the replies!

 

[yesterdays]

	A	B	C	D	E	F	G
1	START	END	MONTH			3/12/2015	MARCH
2	12/28/2014	1/24/2015	JANUARY			4/26/2015	MAY
3	1/25/2015	2/21/2015	FEBRUARY			4/25/2015	APRIL
4	2/22/2015	3/28/2015	MARCH
5	3/29/2015	4/25/2015	APRIL
6	4/26/2015	5/23/2015	MAY
7	5/24/2015	6/27/2015	JUNE
8	6/28/2015	7/25/2015	JULY
9	7/26/2015	8/22/2015	AUGUST
10	8/23/2015	9/26/2015	SEPTEMBER
11	9/27/2015	10/24/2015	OCTOBER
12	10/25/2015	11/21/2015	NOVEMBER
	11/22/2015	12/26/2015	DECEMBER
	12/27/2015	1/23/2015	Jan-16

<tbody>
</tbody>

* shouldn't it been 1/23/2016?
G1:
=INDEX($C$2:$C$14,MATCH(1,($A$2:$A$14<=F1)*($B$2:$B$14>=F1),0))
Ctrl + Shift + Enter

 

[michaxcore]

Yeah it should be 2016. Thank you for finding that mistake and thanks for finding a formula that works, I appreciate it. However I realized I would like that table on a separate sheet so that I can add the sheet to an existing workbook and just enter a formula to calculate the fiscal month. I tried to tweak the formula you provided to work on another sheet but it didn't work. Any ideas on a workaround? Thanks again!

 

[michaxcore]

Nevermind I'm an idiot. I got it to work on a separate sheet. THANK YOU SO MUCH!