Hi All,
Wonder if anyone can help. I have two separate workbooks, and need date information in one to populate into the other.
I have linked the cells (so when I update the dates in workbook 1, they automatically update in workbook 2).

However, before I put a date into workbook 1, the cells are blank. These cells show as "00/01/1900" in workbook 2. I want to hide this so that it doesn't look strange when people open the workbook. I have tried conditional forming but this wont work as the cells are linked to the other workbook.
This is the 'error' that I get on the cells...
Capture2.PNG
Any ideas?

Thanks all.