try
=IF(LEN(TRIM(H41))<1,"",TEXT(H41,"ddd"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steved" wrote in message
...
Hello from Steved

What is required please to the below to have the "cell blank" as at the
moment it displays Sat.

=TEXT(H41,"ddd")

Thankyou.