Conditional formatting

[wiersma7]

I have 2 columns that have dates. In column 1 I enter a date. Column 2 is
linked to the first column. If there is no date in column 1, column 2 then
(for I don't know what reason) has "Saturday, January 00, 1900". I want
column 2 to look exactly like column 1. How can I get column 2 to be blank
like column 1?
I was trying as a work around to format column 2 in white if it showed
"Saturday, January 00, 1900".
Thanks,
wiersma7

 

[amag]

I have 2 columns that have dates. In column 1 I enter a date. Column 2 is
linked to the first column. If there is no date in column 1, column 2 then
(for I don't know what reason) has "Saturday, January 00, 1900". I want
column 2 to look exactly like column 1. How can I get column 2 to be blank
like column 1?
I was trying as a work around to format column 2 in white if it showed
"Saturday, January 00, 1900".
Thanks,
wiersma7

You might have column 2's formatting as 'date format' ...change the
formatting of column 2 to same as column 1. Ctrl2 on coulmn 1 and then
alt e-s-t on column 2.

hope that helps

Rgds/Agg

 

[T. Valko]

Column 2 is linked to the first column.

Try something like this:

=IF(A1="","",A1)