Hopefully this is quite a simple one
In Cell A1 i have a date
in cells d1 :e10 I have a table of date ranges and in f1:f10 I have a number
eg
What I would like is a formula to find which range the date in A1 falls within and then return the number that corresponds in column F. I would be putting this in B1
In the example i've been using (table below) I have used month start and end dates but in the real version the range may not be whole months or may be longer than a month.
Any help appreciated
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" span="2" width="71"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>
In Cell A1 i have a date
in cells d1 :e10 I have a table of date ranges and in f1:f10 I have a number
eg
What I would like is a formula to find which range the date in A1 falls within and then return the number that corresponds in column F. I would be putting this in B1
In the example i've been using (table below) I have used month start and end dates but in the real version the range may not be whole months or may be longer than a month.
Any help appreciated
d | e | f |
01/03/2014 | 31/03/2014 | 1 |
01/04/2014 | 30/04/2014 | 2 |
01/05/2014 | 31/05/2014 | 3 |
01/06/2014 | 30/06/2014 | 4 |
01/07/2014 | 31/07/2014 | 5 |
01/08/2014 | 31/08/2014 | 6 |
01/09/2014 | 30/09/2014 | 7 |
01/10/2014 | 31/10/2014 | 8 |
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" span="2" width="71"> <col style="width: 48pt;" width="64"> <tbody>
</tbody>