Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nokose451
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to look up and return smallest date from a range of dates BJ Excel Worksheet Functions 5 December 7th 05 11:35 PM
Date Range and calculation vgreen Excel Worksheet Functions 2 August 23rd 05 11:08 AM
Excel - return a picture or range rows as the result of a formula juststarting Excel Worksheet Functions 1 July 4th 05 12:59 AM
Return a date 6 months from a date in another cell Qaspec Excel Worksheet Functions 1 January 21st 05 05:59 PM
How can I sum information in a list with a date range? Dave Excel Worksheet Functions 2 November 23rd 04 09:17 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"