I am using:
=TEXT({K24}, "ddd")
But is K24 is blank then the results always equals "Sat" how can I get a blank K24 to result in ""?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI am using:
=TEXT({K24}, "ddd")
But is K24 is blank then the results always equals "Sat" how can I get a blank K24 to result in ""?
Use if()
, like this:
=if(K24, text(K24, "ddd"), iferror(1/0))
Alternatively, use Format > Number > Custom date and time to set the date format to Day as abbreviation.
Try this one, for example:
=iferror(TEXT({K24}, "ddd"))
Since this does not work with reference to a cell, (just to smile) I am writing other three that do work:
=TEXT({""&K24}, "ddd")
or
=TEXT({upper(K24)}, "ddd")
or
=TEXT({join(,K24)}, "ddd")