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

[SOLVED] Get Month Name from Cell of Another Sheet

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


Joined: 10 Oct 2009
Posts: 2

PostPosted: Sat Oct 10, 2009 12:34 pm    Post subject: [SOLVED] Get Month Name from Cell of Another Sheet Reply with quote

Hello everyone! I hope I can explain what I'm trying to accomplish.

I have a document which is essentially a huge time card for employees for an entire month. Every week is on a different sheet. I have two sheets at the end - one is a monthly totals type of sheet, the next is sort of a setup sheet for the whole document.

On the setup sheet I enter a date and it calculates the dates for the weeks, the name of the month, number of days in the month, etc., etc.

On my month totals sheet I have a cell that is basically a title for the sheet. I'm trying to get it to read: "October 2009 Weekly Totals".

I want it to pull the name of the month from a cell on the setup sheet that holds a date. So far I can get it to pull the number of the month (ie: 10) but I can not figure out how to get the name of the month.

Here is the formula I am using to get the title from data on the setup sheet:

=MONTH('Time Card Setup'.B1)&" "&'Time Card Setup'.B3&" Weekly Totals"

'Time Card Setup'.B1 = 10/1/09
'Time Card Setup'.B3 = 2009 (the year)

Any ideas?

Thank you in advance.

P.S. I am aware the I could have just as easily pulled the year from the same cell...


Last edited by checkmate3001 on Sat Oct 10, 2009 1:18 pm; edited 1 time in total
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Oct 10, 2009 12:56 pm    Post subject: Reply with quote

=TEXT(some_numeric_cell;"MMMM YYYY")&" Weekly Totals"
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
checkmate3001
Newbie
Newbie


Joined: 10 Oct 2009
Posts: 2

PostPosted: Sat Oct 10, 2009 1:17 pm    Post subject: [SOLVED] Get Month Name/Year From Date Inside Another Cell Reply with quote

Thank you very much!!!

That was too easy.

P.S. That TEXT() tid-bit just helped me clean up sooooooo many formulas.

EXTREMELY HELPFUL!
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