View Single Post
 
Old 02-12-2016, 02:52 PM
rspiet rspiet is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Nov 2014
Posts: 12
rspiet is on a distinguished road
Default 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.
Attached Files
File Type: xlsx DateRangeExample.xlsx (17.1 KB, 14 views)
Reply With Quote