| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a specified date when it falls within a range....
Hello all. I hope someone can help me figure this one out. So here we go.... I have a spread sheet that you plug in a date and then enter another date manually. The second date is the on I would like to automate. I need the first date to be complared in a range of dates and then return the effective date. Example: Entered date - 01/08/2006 Range Table: Effective: 01/01/2006 - 01/05/2006 01/05/2006 01/06/2006 - 01/10/2006 01/10/2006 01/11/2006 - 01/15/2006 01/15/2006 I would like it to return the 01/10/2006 effective date for that range. Any help is appreciated. -- Nokose451 ------------------------------------------------------------------------ Nokose451's Profile: http://www.excelforum.com/member.php...o&userid=30528 View this thread: http://www.excelforum.com/showthread...hreadid=501829 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return a specified date when it falls within a range....
Use VLOOKUP:
If your data is in cols A,B,C and the target is in F1 then =VLOOKUP(F1,A1:C3,3,TRUE) will return the desired value. -- Gary's Student "Nokose451" wrote: Hello all. I hope someone can help me figure this one out. So here we go.... I have a spread sheet that you plug in a date and then enter another date manually. The second date is the on I would like to automate. I need the first date to be complared in a range of dates and then return the effective date. Example: Entered date - 01/08/2006 Range Table: Effective: 01/01/2006 - 01/05/2006 01/05/2006 01/06/2006 - 01/10/2006 01/10/2006 01/11/2006 - 01/15/2006 01/15/2006 I would like it to return the 01/10/2006 effective date for that range. Any help is appreciated. -- Nokose451 ------------------------------------------------------------------------ Nokose451's Profile: http://www.excelforum.com/member.php...o&userid=30528 View this thread: http://www.excelforum.com/showthread...hreadid=501829 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
| Date Range and calculation | Excel Worksheet Functions | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
Hybrid Mode
