It display's Sat
 

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.

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.

It display's Sat
 

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.

It display's Sat
 

Thankyou.

"Don Guillett" wrote:

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.

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.