Help with referencing DATE cells...

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
 
F

Frank Kabel

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

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

Please help! date showing as 1900/01/00 2
Empty Cells 5
separating date and time 5
copying date from one sheet to another work sheet 13
VLOOKUP 6
Peculiar default cell format 1
Returning a YES or NO if there is a value on a range of cells 0
Payment calculation 1

Top