Excel 2007 : formula to return the next date after todays date in an array and not returning #VALUE!

[Dahdrael]

Hi Everyone

I am having a little trouble with my formula.
{=MIN(IF(N3:AP3>TODAY(),N3:AP3))}
i have some dates in cell N3 going all the way up to AP3
most of these dates are generated through formulas and some are entered manually - unless criteria are met some of these cells read as #VALUE!
when i enter my formula it returns as #VALUE! - if i alter the formula to be N3 through to R3 which all have dates entered in them it works, but if i include cells that have #VALUE! in them the formula doesn't work.

I need to be able to have it search the N3 to AP3 range and return the next date after todays date but not pick up on #VALUE!

any help would be much appreciated

Using excel 2007

Thankyou

[dilipandey]

Hi Dahdrael,

Welcome to the forum.

Try using below formula:-

=MIN(IF(ISERROR(IF($N$3:$AP$3>TODAY(),$N$3:$AP$3,"")),"",IF($N$3:$AP$3>TODAY(),$N$3:$AP$3,"")))

Regards,
DILIPandey

<click on below 'star' if this helps>

[Dahdrael]

Works perfectly, thank you very much