Lookup date in row > today

**spinoza83** · 12-22-2011, 05:46 AM

Dear all,

I am searching through several forums but did not find a satisfiyng answer to my probblem yet.
I cannot solve a part of an index function that is a as followed:

I am looking for a formula that search in a row with all kinds of dates. It must than give me the first date that is greater than today.
I already tried combining a hlookup with an if function but I get an error everytime.
Does somebody know an answer to this problem?

Thanks

Regards Ralph

**edvwvw** · 12-22-2011, 10:57 AM

Welcome to the board:

=INDEX(G9:AJ9,MATCH(TODAY()+1,G9:AJ9))

If the date range is in G9 - AJ9

edvwvw

**spinoza83** · 12-22-2011, 11:15 AM

Hi edvwvw, thank for your answer.

However when the range is as followed:
40,287 40,646 40,737 40,923 41,000 41,090 41,213

The formula shows 40,737, so this is <today.
So somehow the formula is wrong.

You have any idea why?

Thansk for quick reaction!

Regards Ralph

**NBVC** · 12-22-2011, 11:16 AM

or perhaps:

=INDEX(A2:Z2,MATCH(TRUE,INDEX(A2:Z2>TODAY(),0),0))

where A2:Z2 contains the row of dates.

**edvwvw** · 12-22-2011, 11:23 AM

This will do it

=INDEX(C8:I8,MATCH(TODAY()+1,C8:I8,TRUE)+1)

edvwvw

**spinoza83** · 12-22-2011, 11:41 AM

Thanks this works!

Regards Ralph

Both the solution from edvwvw and nbvc works!

**NBVC** · 12-22-2011, 11:55 AM

For the sake of future users looking at this thread, please identify the solution that worked and then...

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save