View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
KrisP KrisP is offline
external usenet poster
 
Posts: 8
Default Show day or empty cell

Thanks to both of you, thats great.

"KrisP" wrote:

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