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

Copper Contributor



   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!


2 Replies


Try this one:



Why do you need WEEEKDAY() here?

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