Excel function glitch?
 

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.

Excel function glitch?
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bdog" wrote in message
...
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.