Show day or empty cell

[KrisP]

Hello,
Im using the formula =TEXT(A1, "ddd") to show the day from a date. How can
I make it show an empty cell if there is nothing in cell A1?
Sorry for the simply question, I'm new to this!

Many thanks in advance

 

[Mike H]

try,

=IF(A1="","",TEXT(A1, "ddd"))

Mike

 

[Joel]

=if(A1<>"",TEXT(A1, "ddd"),"")

 

[Mike H]

You may wish to consider this formula instead of what you are using. It has
the advantage of being easier to perform calculations on

=IF(A1="","",WEEKDAY(A1))

Mike

 

[KrisP]

Thanks to both of you, thats great.