View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default It display's Sat

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

instead of =TEXT(H41,"ddd")

"Steved" wrote:

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.