Converting date to day of the week, if no date leave blank

Question

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 ""?

Welcome to Web Applications. Use IF and ISBLANK functions.
– Rubén ♦
Apr 23 at 16:22 — Rubén, Apr 23 at 16:22

doubleunary · Accepted Answer · 2022-04-23 17:44:20Z

1

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.

answered Apr 23 at 17:44

doubleunary

6,7631 gold badge4 silver badges34 bronze badges

Add a comment |

Daniele · Accepted Answer · 2022-04-23 21:20:58Z

-1

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")

answered Apr 23 at 17:35

Daniele

1,2511 gold badge2 silver badges12 bronze badges

I would like the one who gave the -1 to my answer to also give me the motivation ... I still believe that my answer is correct and answers the question exactly. I am always ready to accept any right correction.
– Daniele
Apr 23 at 18:38
ok... I understand the -1 :) I had tried with numbers inside the brackets, not with a specific cell ... with numbers it works, with a cell it doesn't.
– Daniele
Apr 23 at 19:58

Add a comment |

2 Answers 2