Once again Danny to the rescue!
Thanks!

"kim" wrote:

I have anticipated ship date in workbk 'Full Log'!K5
I want anticipated ship date in 'Sub Log'!F5
When I put in formula ='Full Log'!K5 and there is no value in the column, I
get 01/0/1900 and I don't want that I would prefer for it to be blank for the
people who are looking at the information are becoming confused. How can I
do it?