How do I get the name of the weekday

_dave · June 29, 2021, 1:59pm

I would like to add the name of the day to a column, how can I do this?
Example of my current spread sheet:

DATE     DAY       TIME
06/26/21	       08:30:00 AM

What I would like:

DATE     DAY       TIME
06/26/21 Saturday  08:30:00 AM

Thanks ahead for any solutions or suggestions.

[Edit - Opaque] formatted data as preformatted text

anon73440385 · June 29, 2021, 2:10pm

Hello,

assuming

06/26/21 is in cell A2
06/26/21 is a real Calc date (i.e. is a number)
weekday should be in B2

then showing the full day name is just a matter of formatting the date, hence:

set formula =A2 into cell B2
format cell B2 using format code DDDD

See the following sample file: Q316167.ods

Hope that helps.

_dave · June 29, 2021, 3:28pm

Just what I need, thanks. Is it possible to do this for the whole column taking in account for missing dates in the “A” column?

anon73440385 · June 29, 2021, 3:40pm

Sure - if no value in A then no value shown in B and formatting “nothing” to DDDD shows … nothing.

karolus · June 29, 2021, 6:57pm

@_dave:
=IF( A2 ; A2 ; "" ) and copy down.

erAck · June 29, 2021, 7:56pm

@anon73440385:

if no value in A then no value shown in B and formatting “nothing” to DDDD shows … nothing

Not true, because the empty cell is propagated as 0 which yields the null date 1899-12-30 displayed with DDDD as Saturday.

_dave · June 30, 2021, 4:40am

karolus, thank you for the solution of the blank cell, my problem is solved. Also, again thanks to Opaque for the correct cell format for the day. Also, I want to thank erAck for “spotting” the error results with a blank cell. I was wondering where “Saturday” came from.