Blank dates showing as 00 january 1900 - help

[Josuha]

I'm using the below forumla to import data from a seperate workbook which
contains dates.It does work for cells that have dates in them but not every
cell has a date yet and i want this to remain blank but it shows as 00
january 1900
=VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)

Any ideas please?

 

[Ms-Exl-Learner]

=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))

Remember to Click Yes, if this post helps!

 

[David Biddulph]

=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))

 

[Josuha]

Your a star!
Many thanks (i pressed yes too )

=IF(VLOOKUP(B8,'Summary '!B2:$K$100,10,FALSE)=0,"",VLOOKUP(B8,'Summary
'!B2:$K$100,10,FALSE))

Remember to Click Yes, if this post helps!