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
Bookmarks