## [Solved] Day of Week?

### [Solved] Day of Week?

Looking for a function/formula that will take a date in a cell and convert it to the corresponding week day e.g. Monday, Tuesday, etc., in another cell.

Searched help subjects and could not find.

TIA
Last edited by Hagar Delest on Tue Jun 10, 2008 2:25 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
halw

Posts: 2
Joined: Fri May 30, 2008 10:27 pm

### Re: Day of Week?

See help on WEEKDAY. If you need the string for display purpose you may combine WEEKDAY with CHOOSE. You could also apply another number format:
A1: some date
B1: =A1 [plus number format "NNN"] yields the same value as in A1, but shows the month name only
You could also get the string value:
B1: =TEXT(A1;"NNN")
TEXT returns the formatted string representation of a number.

 Edit: Sorry, I mixed month names with day names. replaced "MMMM" with "NNN"
Last edited by Villeroy on Mon Dec 17, 2012 6:10 pm, edited 1 time in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x

Villeroy
Volunteer

Posts: 25269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Day of Week?

Villeroy wrote:See help on WEEKDAY. If you need the string for display purpose you may combine WEEKDAY with CHOOSE. You could also apply another number format:
A1: some date
B1: =A1 [plus number format "MMMM"] yields the same value as in A1, but shows the month name only
You could also get the string value:
B1: =TEXT(A1;"MMMM")
TEXT returns the formatted string representation of a number.

Thank you. Was drawing a blank on this.
halw

Posts: 2
Joined: Fri May 30, 2008 10:27 pm

### Re: [Solved] Day of Week?

WHY so complicated?
Open Office 3.4.1 on Mac OS X (this changes all the time so why????)
danuneken

Posts: 1
Joined: Sun Dec 16, 2012 10:03 pm

### Re: [Solved] Day of Week?

danuneken wrote:WHY so complicated?

I don't know but at a guess it is because time is much more complicated to calculate than simple numbers. Three hundred and sixty-five days in a year except when there are 366; 24 hours in a day but don't forget daylight savings time versus standard time, oh and every so often we add a second or so to the time and so on.
OpenOffice 4.1.4 Ubuntu 16.04 Xenial Xerus
jrkrideau
Volunteer

Posts: 3484
Joined: Sun Dec 30, 2007 10:00 pm

### Re: [Solved] Day of Week?

halw wrote:Looking for a function/formula that will take a date in a cell and convert it to the corresponding week day e.g. Monday, Tuesday, etc., in another cell. ...

With the date in A1, =TEXT(A1;"NNN")
AOO4/LO5 • Linux • Fedora 23

acknak
Moderator

Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3