Return a Blank if criteria field is blank when using dates

[STINSON]

If I am using the below formula =IF(ROWS(D$8:D8)<=K$5,INDEX(Sheet1!$D$7:$D$1000,SMALL(IF(Sheet1!$O$7:$O$1000="Temporary",ROW(Sheet!$O$7:$O$1000)-ROW(Sheet!$O$7)+1),ROWS(D$8:D8))),"")

I do I get the TermDate in Sheet2 to be blank (not return anything) if the TermDate in Sheet 1 is blank. It currently returns 1/0/1900. I can adjust it by formatting but this causes problems when a TermDate is eventually entered.


F5:Count of temporary employees from Sheet1
D7:D1000: TermDate on Sheet1
O7:O1000: Employee Type on Sheet1 (Temporary)
D8: First cell in TermDate column on Sheet2

Any help you can provide would be greatly appreciated. Thank you.

[Tony Valko]

So the formula returns dates?

Maybe this...

=IFERROR(1/(1/INDEX(Sheet1!$D:$D,SMALL(IF(Sheet1!$O$7:$O$1000="Temporary",ROW(Sheet1!$O$7:$O$1000)),ROWS(D$8:D8)))),"")

Still array entered.

[STINSON]

You are fantastic, thank you!

All of your solutions have been useful and solved my issues.

[Tony Valko]

You're welcome. Thanks for the feedback!