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
|