I forgot to include the "=" :

=IF(AND(ISNUMBER($B1),$B10),TEXT($B1,"dddd"),"")

This version is more robust:

=IF(COUNT(B1,--(B10))=2,TEXT(B1,"dddd"),"")


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try it like this:

IF(AND(ISNUMBER($B1),$B10),TEXT($B1,"dddd"),"")



--
Biff
Microsoft Excel MVP


wrote in message
...
I'm using Excel 2003. I'm trying to use conditional formatting to have
a blank cell change to the day of the week when a date is entered into
another cell.