=IF(F1="","",TEXT(F1,"DDDD"))

BTW "DDDD" will show Thursday only

If you want 3/1/08 Thursday, use "d/m/yy DDDD"


Gord Dibben MS Excel MVP


On Fri, 8 Feb 2008 16:00:05 +1100, "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