Hi,

I am trying to display a blank entry as a blank instead of Jan 00. I have tried the following formula but no joy, would anybody be able to have a look to see what I am doing wrong?

=IF''"&$A30&''!B:B"="";"";MAX(INDIRECT("'"&$A30&"'!B:B))+$B$4)

Rgds
Harry