Need a little advice for next date after today in a range

[camle]

Would like to get the next date from a range with a list of dates

=IFERROR(MAX(INDIRECT("'"&D8&"-TVDB'!$C$1:$C$50000"),"<"&TODAY()*"'"&D8&"-TVDB'!$C$1:$C$50000"),"None"

Having trouble finding why it's not picking up the next date after today.
The return is always "None"

Thanks

 

[Roderick_E]

For one, there is no closing paren at the end of "None") Secondly if there more conditions you're not showing us?

 

[camle]

True the paren was not copied in the ex. above, so thank you for noticing that.

D8 = are different names
Ex. The Simpsons-TVBD

INDIRECT("'"&D8&"-TVDB'!$C$1:$C$50000") points to the tab named "The Simpsons-TVBD"
in the range from C1:50000 are a list of dates:

11/20/2017
11/27/2017
12/15/2017
12/28/2017
1/10/2018

I wanted the formula to select 1/10/2018, with today being 12/28/2017
All cells involved have just the data in them, no time.
They are formatted short date.

 

[Roderick_E]

This returns TRUE but isn't what you really want:

=IFERROR(MAX(INDIRECT("'"&D8&"'!$C$1:$C$50000"))<TODAY()*MAX(INDIRECT("'"&D8&"'!$C$1:$C$50000")),"None")

 

[camle]

=IFERROR(MAX(INDIRECT("'"&D8&"-TVDB'!$C$1:$C$50000")),"None")

Little mod to the formula, because I got an error missing a paren
But it does work on some worksheets being referenced.
On other sheets it will go past the next date (closest to today) skipping 1 or more, some going all the way to the end of the list.

Thanks