# If date is between x and y, then z

#### mniedert

##### Board Regular
I'm betting this will be an easy one for somebody...

Column A has a list of our Fiscal Quarters (2015-Q1, 2015-Q2, 2015-Q3, etc.)
Column B has the start date of that quarter
Column C has the end date of that quarter

Like this;
Column A Column B Column C
2015 - Q1 12/29/2014 2/27/2015
2015 - Q2 2/28/2015 5/29/2015
2015 - Q3 5/30/2015 8/28/2015
2015 - Q4 8/29/2015 11/27/2015

I need a formula that would give me the correct Fiscal Quarter, if I typed in any date in E1. So if I typed in 4/20/2015 in E1, it would give me "2015 - Q2" in F1. If I typed in 8/30/2015 in E1, it would give me "2015 - Q4"

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
=index(a:a,match(e1,b:b,1))

Thank you so much!

Replies
5
Views
266
Replies
2
Views
120
Replies
2
Views
159
Replies
2
Views
196
Replies
0
Views
199

1,203,078
Messages
6,053,403
Members
444,662
Latest member
AaronPMH

### 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.

### Which adblocker are you using?

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

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