[Solved] Day of Week?

Discuss the spreadsheet application

[Solved] Day of Week?

Postby halw » Fri May 30, 2008 10:34 pm

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?

Postby Villeroy » Fri May 30, 2008 11:37 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Day of Week?

Postby halw » Sat May 31, 2008 12:50 am

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?

Postby danuneken » Sun Dec 16, 2012 10:04 pm

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?

Postby jrkrideau » Mon Dec 17, 2012 2:18 pm

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.
AOO 4.0.1, Ubuntu 13.04
jrkrideau
 
Posts: 1910
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: [Solved] Day of Week?

Postby acknak » Mon Dec 17, 2012 5:56 pm

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")
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17403
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests