Try this, im assuming you are using that formula and dragging it down across
multiple rows... so in F1 put the formula

=IF(OR(F1=0,F1=""),"",TEXT(F1,"dddd"))

Then drag and drop that formula.

"sureshift" wrote:

I have this equation.
=Text(f1,"DDDD") Which comes out as 3/1/08 Thursday.
How do I get it to come up blank till I put in a date.
At the moment it comes up like this.
3/1/08 Thursday
Friday
Friday
Thanks in advance Larry