Find a Date in a Range
The attached spreadsheet contains a range of beginning and ending dates along with some other data in A2 thru D13. In column E2 there is a date value. I need a formula that will search for which date range the date in E2 is in and find the group leader for that date range in F2.
Note, the data itself for this is just a made up sample made up in order to create the formula. My real application is much more complex.
|