Excel function glitch?

[bdog]

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="",0,IF($D50<>0,weekdayd50,0)), and this does not work either.

 

[Bob Phillips]

=IF(E50="","",WEEKDAY(E50))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)