Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form return lookup values
I have a table that has three start dates. I need use an employees start
date as a reference point compare it to todays date and find the next date in the column and return it to a textbox in a form. Then I need to return the next four dates in the column to the form. Dec 22, 2008 Dec 26, 2008 Dec 29, 2008 Jan 12, 2009 Jan 16, 2009 Jan 19, 2009 Feb 02, 2009 Feb 06, 2009 Feb 09, 2009 Feb 23, 2009 Feb 27, 2009 Mar 02, 2009 Mar 16, 2009 Mar 20, 2009 Mar 23, 2009 Apr 06, 2009 Apr 10, 2009 Apr 13, 2009 Apr 27, 2009 May 01, 2009 May 04, 2009 May 18, 2009 May 22, 2009 May 25, 2009 Jun 08, 2009 Jun 12, 2009 Jun 15, 2009 Jun 29, 2009 Jul 03, 2009 Jul 06, 2009 So if the start date is Dec 26, 2008 and today€˜s date is Feb 18, 2009, the return date should be Feb 27, 2009. I have code that brings in the start date but need help with code to find the next date after todays date and the next four values. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form return lookup values
Is this array forula what you want?
=INDEX(A1:C10,MATCH(TODAY(),INDEX(A1:C10,0,MIN(IF( A1:C1=startdate,COLUMN(A1:C1)))),1)+1,MATCH(startd ate,A1:C1,0)) -- __________________________________ HTH Bob "Tony" wrote in message ... I have a table that has three start dates. I need use an employee's start date as a reference point compare it to today's date and find the next date in the column and return it to a textbox in a form. Then I need to return the next four dates in the column to the form. Dec 22, 2008 Dec 26, 2008 Dec 29, 2008 Jan 12, 2009 Jan 16, 2009 Jan 19, 2009 Feb 02, 2009 Feb 06, 2009 Feb 09, 2009 Feb 23, 2009 Feb 27, 2009 Mar 02, 2009 Mar 16, 2009 Mar 20, 2009 Mar 23, 2009 Apr 06, 2009 Apr 10, 2009 Apr 13, 2009 Apr 27, 2009 May 01, 2009 May 04, 2009 May 18, 2009 May 22, 2009 May 25, 2009 Jun 08, 2009 Jun 12, 2009 Jun 15, 2009 Jun 29, 2009 Jul 03, 2009 Jul 06, 2009 So if the start date is Dec 26, 2008 and today's date is Feb 18, 2009, the return date should be Feb 27, 2009. I have code that brings in the start date but need help with code to find the next date after today's date and the next four values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup 2 values to return 1 | Excel Worksheet Functions | |||
Lookup 2 values and return a third | Excel Worksheet Functions | |||
User form return values | Excel Programming | |||
How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |