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

On May 26, 8:28*am, "wiersma7" <wiers...@comcast.net> wrote:
> 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

>Column 2 is linked to the first column.

Try something like this:

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

--
Biff
Microsoft Excel MVP


"wiersma7" <wiersma7@comcast.net> wrote in message
news:OO26SAuvIHA.5584@TK2MSFTNGP02.phx.gbl...
>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
>