Replacing 00/01/1900 dates with blanks

Replacing 00/01/1900 dates with blanks

Hi,

In a column ‘A’ on Sheet1 I have a list of dates (in the format dd/mm/yyyy) and I am using the formula in column ‘A’ on Sheet2 e.g. =Sheet1!A2 copied down the column to populate the same dates, however, if a cell is empty on Sheet1 it will report the date 00/01/1900 in the corresponding cell in Sheet2.

e.g.

please see attached 'Example.xlsx' file

Is there anyway to return a blank cell as opposed to retuning 00/01/1900 in column A on Sheet2 ?

Many thanks in advance

Regards

Rob

N.B. Excel Version 2007

If you use this custom format

dd/mm/yyyy;;

with the two semi-colons at the end then zero/blank date values will be displayed as blanks

Sorry

see Example file attached


Rob

daddylonglegs

Many thanks it worked as required, many thanks for your prompt reply


Regards


Rob

or use
=IF(Sheet1!A2="","",Sheet1!A2)