Bypass Jan-1900

[avk]

Hello

Excel2007 sheet.
I m using formula =MAX(IF((Q2:AB2<=$AK$1)*(Q2:AB2>=$AJ$1), Q2:AB2,""))

In q2:ab2 range column verious dates some is blank.
In aj1 start date
In ak1 end date

As per above formula, display date between start & end date from range.

But if date not found from range q2:ab2 then display date as Jan-1900 (formating mmm/yyyy)

I required cell blank: if date is Jan-1900 with using above formula.

Also we using second formula and second formula is : =INT(AE2-TODAY())
if ae2 is blank then show #value!
I also required bypass #value with using formula.
Required cell balnk : if show #value!
formating : general

[NBVC]

You can format the cell as Custom:

mmm/yyyy;;;@

[daddylonglegs]

...and you can adjust your other formula like this

=IF(AE2="","",INT(AE2-TODAY()))

or with IFERROR

=IFERROR(INT(AE2-TODAY()),"")

[avk]

Thanks. Our problem solved.