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

Question

Hello,&nbsp;&nbsp; &nbsp;I am using a this formula to grab the 'day of week' from a column of dates:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=TEXT(WEEKDAY(A69), "ddd")&nbsp;&nbsp;&nbsp;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

patrick2788 · Answer

HeyRob950&nbsp;Try this one:=IF(A69="","",TEXT(WEEKDAY(A69),"ddd"))

sergeibaklan · Answer

HeyRob950&nbsp;
Why do you need WEEEKDAY() here?
=IF(A1&lt;&gt;"", TEXT(A1, "ddd"), "" )
works.

Forum Discussion

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

2 Replies

Resources