View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default It display's Sat

Thankyou

"Sheeloo" wrote:

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.