[SOLVED] Get Month Name from Cell of Another Sheet

checkmate3001 · Newbie Joined: 10 Oct 2009 Posts: 2

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...

Villeroy · Posted: Sat Oct 10, 2009 12:56 pm Post subject:

=TEXT(some_numeric_cell;"MMMM YYYY")&" Weekly Totals"
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

checkmate3001 · Newbie Joined: 10 Oct 2009 Posts: 2

Thank you very much!!!

That was too easy.

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

EXTREMELY HELPFUL!