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

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!

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

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)

--
Allllen


"AmnNkD" wrote:

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!

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

Hi

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


--
Regards

Roger Govier


"AmnNkD" wrote in message
...
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!