IF statement to return a blank

I have this IF statement in cell M6 in Tab 1: =IF(OR($A6="",$B6=""),"",INDEX(INDIRECT("'"&$B6&"'!k:k"),$A6))

What this does is that the cell populates according to other cells and corresponding cells in Tabs 2-15 columns A-M.

When cells in Tabs 2-15 are blank, cell M6 in Tab 1 returns a value of 0-Jan-00. How can I change that so that it returns a blank cell if a date has not been entered yet?

Any help is appreciated. Thank you.

Are all the cells expected to return dates, or are some of them returning text and/or other numbers?

Pete

Originally Posted by Pete_UK

Are all the cells expected to return dates, or are some of them returning text and/or other numbers?

Pete

All cells are expected to return dates. The cells are also formatted for dates.

Okay, in that case the simplest way would be to apply a custom format to the cells of:

d-mmm-yy;;

The two semicolons at the end (well, actually the final one) will cause a zero result to be displayed as a blank.

Hope this helps.

Pete

Originally Posted by Pete_UK

Okay, in that case the simplest way would be to apply a custom format to the cells of:

d-mmm-yy;;

The two semicolons at the end (well, actually the final one) will cause a zero result to be displayed as a blank.

Hope this helps.

Pete

Worked like a charm! Thank you...you are awesome!

Glad to be able to help - thanks for the rep.

Pete