Put this in your blank cell instead and with a date in B1 you get the day of
the week,

=TEXT(B1,"dddd")

Mike

" wrote:

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.