OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Work out which day from date

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
zaynt
General User
General User


Joined: 10 Jul 2006
Posts: 10

PostPosted: Tue Oct 17, 2006 3:22 pm    Post subject: Work out which day from date Reply with quote

Can I somehow work out what day it was on lets say,12th of octobe,r using OpenOffice Calc?
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Tue Oct 17, 2006 3:25 pm    Post subject: Reply with quote

Use WEEKDAY(...)
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
zaynt
General User
General User


Joined: 10 Jul 2006
Posts: 10

PostPosted: Tue Oct 17, 2006 3:59 pm    Post subject: Reply with quote

I wan't to the output to be like this: Monday, Tueday, Wednesday etc.
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Tue Oct 17, 2006 4:17 pm    Post subject: Reply with quote

zaynt:

In order to 'display' the day of the week, for a date . . . the easy way to do this with Calc Spreadsheet is:

If, for example, cell A2 contains your date . . . as you described . . . 2006-10-12 . . . in cell B2, put . . . =A2 and, then from the menu:

Format -> Cells... -> on the NUMBERS tab, Category, select Date, Format Code, enter DDDD

This will, display the day of the week, spelled out completely.

If you only want the first three letters of the date, the Format Code, enter DDD

You could, if you wanted, format the cell you entered the date directly, to only display the day of the week.

I hope this helps, please be sure to let me / us know.

Sliderule
Back to top
View user's profile Send private message
zaynt
General User
General User


Joined: 10 Jul 2006
Posts: 10

PostPosted: Tue Oct 17, 2006 6:10 pm    Post subject: Reply with quote

That worked perfectly, thank you!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group