is blank date

[andyperiam]

I have a spreadsheet that looks for its data from another sheet.
One of the columns is a date not all rows contain a date.

When I reference from this column it correctly puts the date in, but for cells where there is no date it shows 00/01/1900

I would like the cell to remain blank and not give me this 00/01/1900 date.

Any ideas. I am sure it is a simple if statement but am hopeless at those.

[teylyn]

Hi,

I assume you use something like this: In Sheet2 you have a formula like

=Sheet1!A1

instead you could try

=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)

cheers

[andyperiam]

Many Thanks,

Exactly what I was after

[DonkeyOte]

To avoid the need for repetitive call (double evaluation) you might want to think about using a Custom Format on the column itself, ie leave formula as a single call:

=Sheet1!A1

but apply a Custom Format to those cells utilising the above function such that 0 (00/01/1900 in date terms) is neither displayed nor printed (ie appears as a blank), eg a Format of: dd/mm/yyyy;;

(obviously alter the date format to suit)