Show day or empty cell
 

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

Show day or empty cell
 

try,

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

Mike

"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

Show day or empty cell
 

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


"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

Show day or empty cell
 

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

"Mike H" wrote:

try,

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

Mike

"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

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