Find smallest date greater than today

[Cordo]

Hi All,

Interesting one.

i have a list of dates (Unsorted and have to remain that way as they are pulled from a report) and I want to find the smallest date that is greater than todays date.

Any one have any thoughts?

 

[p45cal]

Do you want to show it in another cell, or highlight it in the existing list?

 

[Yahya]

try this Idea

Excel Workbook
	A	B	C	D
1	Date			Date Greater than Today
2	01/05/2011			30/07/2011
3	16/05/2011			14/08/2011
4	31/05/2011			29/08/2011
5	15/06/2011			13/09/2011
6	30/06/2011			28/09/2011
7	15/07/2011			13/10/2011
8	30/07/2011			28/10/2011
9	14/08/2011			12/11/2011
10	29/08/2011			27/11/2011
11	13/09/2011			12/12/2011
12	28/09/2011			27/12/2011
13	13/10/2011
14	28/10/2011
15	12/11/2011
16	27/11/2011
17	12/12/2011
18	27/12/2011
Sheet1

Excel 2007

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[p45cal]

Note this is ARRAY-ENTERED, see notes at bottom:

Excel Workbook
	H	I	J
2			30/07/2011
3	18/09/2011
4	13/06/2011
5	21/08/2011
6	03/06/2011
7	10/09/2011
8	17/08/2011
9	01/09/2011
10	09/06/2011
11	20/08/2011
12	30/05/2011
13	21/08/2011
14	02/07/2011
15	12/06/2011
16	10/06/2011
17	15/09/2011
18	05/07/2011
19	27/06/2011
20	22/08/2011
21	21/09/2011
22	15/06/2011
23	17/06/2011
24	23/07/2011
25	20/06/2011
26	08/09/2011
27	30/07/2011
28	06/06/2011
29	07/07/2011
30	06/06/2011
31	04/09/2011
32	08/07/2011
33	16/09/2011
34	09/07/2011
35	01/07/2011
36	17/07/2011
37	19/09/2011
38	02/07/2011
39	25/08/2011
Sheet14

 

[Cordo]

Note this is ARRAY-ENTERED, see notes at bottom:

Excel Workbook
	H	I	J
2			30/07/2011
3	18/09/2011
4	13/06/2011
5	21/08/2011
6	03/06/2011
7	10/09/2011
8	17/08/2011
9	01/09/2011
10	09/06/2011
11	20/08/2011
12	30/05/2011
13	21/08/2011
14	02/07/2011
15	12/06/2011
16	10/06/2011
17	15/09/2011
18	05/07/2011
19	27/06/2011
20	22/08/2011
21	21/09/2011
22	15/06/2011
23	17/06/2011
24	23/07/2011
25	20/06/2011
26	08/09/2011
27	30/07/2011
28	06/06/2011
29	07/07/2011
30	06/06/2011
31	04/09/2011
32	08/07/2011
33	16/09/2011
34	09/07/2011
35	01/07/2011
36	17/07/2011
37	19/09/2011
38	02/07/2011
39	25/08/2011
Sheet14

That worked perfectly. I've spent ages on that. Cheers for your help!