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.
|