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

Similar Threads

Dates linked in Excel files 3
Publisher is filling blank lines with data 2
ASK Field Formatting 1
Linking sheets how do I display the zeros (0) as blank cells 1
How to update data from linked worksheet back to a master worksheet? 0
How to update a value from a linked worksheet back to the master worksheet? 0
blank date shows up as s 1/0/00 2
date corruption? 00/01/1900 2

Top