How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)

asked 2016-07-21 15:49:17 +0200

EasyRider

1 ●1 ●1 ●1

So far, I have a long, complicated "IF" statement, using WEEKDAY().. There must be an easier way!

edit retag flag offensive close merge delete

add a comment

2

answered 2016-07-21 16:02:24 +0200

karolus

4019 ●15 ●39

Hallo

=TEXT(A1;"NNN")

edit flag offensive delete link

Comments

Better use TEXT(A1;"DDDD") if you eventually want to save in Excel formats, as the "NNN" and "NNNN" format codes are only available in LibreOffice and OpenOffice(.org)

erAck ( 2016-07-28 14:00:27 +0200 )edit

add a comment

1

answered 2016-07-21 16:05:18 +0200

mark_t

1035 ●6 ●11 ●17

Use the CHOOSE function

=CHOOSE(WEEKDAY(J19,2),"Monday", "Tuesday", "Wednesday","Thursday","Friday","Saturday","Sunday")

edit flag offensive delete link

Comments

the question was about easier way… not about sophisticated one

karolus ( 2016-07-23 15:10:32 +0200 )edit

Compared to string of IF functions CHOOSE is easier, but of course TEXT is the best and EasyRider should choose that as the best answer. I looked for FORMAT and didn't realize that function was called TEXT.

mark_t ( 2016-07-23 20:19:35 +0200 )edit

add a comment

-2

answered 2016-10-23 19:12:43 +0200

adam1969in
3 ●3 ●4 ●5

=WEEKDAY(A1)

and formatting the cell as Date - user defined - "NNNN" The other answers are right too.

=Text(A1,"DDDD") will be the best one.

edit flag offensive delete link

Comments

And your answer is wrong, also if it produce accidentally the "right" results.
do never patch some Date-formatting on Values which are no real Dates

karolus ( 2016-10-23 19:31:51 +0200 )edit

The main formula I recommended is =Text(A,"DDDD"), though it wrongly works with Weekday function.

adam1969in ( 2016-10-25 04:51:15 +0200 )edit

add a comment

How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)

3 Answers

Comments

Comments

Comments

Question Tools

Stats

Related questions

How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016) edit

3 Answers

Comments

Comments

Comments

Question Tools

Stats

Related questions

How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)