software

When I enter in a date in one cell, I have another cell I want the day of the
week to show up. In this cell I have =weekday(e51), and it gets me the day
of the week fine, but in the other cells it defaults to Saturady, when I just
want the cell to be blank until I enter in a date in the other cell. Is
there a way to not get Saturay showing up? I have tried inputing
=IF($E50=quot;quot;,0,IF($D50lt;gt;0,weekdayd50,0)), and this does not work either.

=IF(E50=quot;quot;,quot;quot;,WEEKDAY(E50))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;bdogquot; gt; wrote in message
...
gt; When I enter in a date in one cell, I have another cell I want the day of
the
gt; week to show up. In this cell I have =weekday(e51), and it gets me the
day
gt; of the week fine, but in the other cells it defaults to Saturady, when I
just
gt; want the cell to be blank until I enter in a date in the other cell. Is
gt; there a way to not get Saturay showing up? I have tried inputing
gt; =IF($E50=quot;quot;,0,IF($D50lt;gt;0,weekdayd50,0)), and this does not work either.