Linked date field in worksheet defaults a blank field as 1/0/1900

[Guest]

I have a workbook that has several worksheets linked. When the date fields
are blank in the orginial worksheet the worksheet they are linked to shows
the dates as 1/0/1900, not a blank field. Does anyone know how to fix this?
Thank you!

 

[Guest]

Let's say SourceSheet is the sheet where you have your date, in Cell A1.
TargetSheet cell A1 is where you are going to pull in the date from
SourceSheet A1.

At the moment your formula in TargetSheet A1 is something like this
=SourceSheet!A1

You need to change it to this
=IF(SourceSheet!A1="","",SourceSheet!A1)

 

[Roger Govier]

Hi

Include an If statement in your formula like
=IF(Sheet1!A1="","",Sheet1!A1)