It display's Sat

[Steved]

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.

 

[Sheeloo]

Try
=IF(H41="","",TEXT(H41,"ddd"))

instead of =TEXT(H41,"ddd")

 

[Don Guillett]

try
=IF(LEN(TRIM(H41))<1,"",TEXT(H41,"ddd"))

 

[Steved]

Thankyou.

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

 

[Steved]

Thankyou

Try
=IF(H41="","",TEXT(H41,"ddd"))

instead of =TEXT(H41,"ddd")