|
|
#1
02-12-2016, 02:52 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Check if a Date falls within a date range | OTPM | Excel | 7 | 02-03-2016 09:11 PM |
 MS Project Date Range Issue
|
appelguy@gmail.com | Project | 2 | 10-31-2015 11:52 AM |
| find IP in range / find number between numbers | gn28 | Excel | 4 | 06-14-2015 03:46 PM |
|
Restrict Date Range Calculations
|
akatz85 | Excel | 4 | 03-27-2014 08:46 PM |
|
Date Range Prompt
|
MikeWooZ | Excel | 6 | 12-04-2011 02:10 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode