=IF(ISBLANK(F1),"",TEXT(F1,"dddd"))

Steve



"Neil" wrote in message
...
i have a formula that returns the day of a inoutted date.

=TEXT(f1,"dddd")

it works fine except for it will return a "saturday" if the cell is blank.
How can i adapt it to ignore the blank cell?

Many thanks