Not getting blank cell if there is no value in formula cell

Copper Contributor

Hello,

 

   I am using a this formula to grab the 'day of week' from a column of dates:  

 

 

 

=TEXT(WEEKDAY(A69), "ddd")

 

 

 

Unfortunately, if there is no value in A69, then the cell this formula is applied to gives me 'Sat' instead of a blank/empty cell. Is there an easy way to resolve this? Any help is greatly appreciated!

Rob

2 Replies

@HeyRob950 

Try this one:

=IF(A69="","",TEXT(WEEKDAY(A69),"ddd"))

@HeyRob950 

Why do you need WEEEKDAY() here?

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

works.