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

A

AmnNkD

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!
 
A

Allllen

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)
 
R

Roger Govier

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top