showing day from date and blank if empty

[Mattlake]

Hi

This may be a silly question.

I need to show a day from a date , I have used the formula =TEXT(B40,"dddd") but I want to show blank if there is no date entered.

I cannot seem make it go blank.

Any help would be much appreciated.

Thank you

Matthew

 

[Fluff]

How about

=IF(B40="","",TEXT(B40,"dddd"))

 

[Mattlake]

why is it so simple

Thank you for this it works perfect

 

[Fluff]

You're welcome & thanks for the feedback.