Help with referencing DATE cells...

  • Thread starter Thread starter Robbostar
  • Start date Start date
R

Robbostar

Background: I am referencing DATE data from one sheet to another.

The problem is in the column used for 'date' since it gives th
following date 00/01/1900 when the reference is made to a blank DAT
cell in the original sheet.

What I need is for it to become blank as the original 'date' cell an
not have it default to 00/01/1900...


Cheers,
Ro
 
Hi
try something like
=IF('sheet1'!A1="","",'sheet1'!A1)
where A1 is your cell with a date value
 
Back
Top