Matching Month number with Month Name

[BrianHall]

Good morning,

I'm looking for an Excel formula to put into Tab #1 (cell A6)that will change automatically when the number month in Tab #1 (cell A4) changes. I already have a formula that drives the change in Tab #1 (cell A4) based upon data in Tab #2. Any assistance would be greatly appriciated.

Thank you

Brian

	Tab #1
Cell	A
4	11
5
6	November
	Tab #2
Cell	A	B	C	D	E	F	G	H
2	Month	Month #		Enter the Current Report Month #	11
3	January	1
4	February	2
5	March	3
6	April	4
7	May	5
8	June	6
9	July	7
10	August	8
11	September	9
12	October	10
13	November	11
14	December	12

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" span=7 width=64><TBODY>
</TBODY>

 

[njimack]

You don't need to refer to tab 2.
=TEXT(DATE(YEAR(TODAY(),A4,1),"mmmm")

 

[BrianHall]

Good morning Neil,

Thank you for your replay. When I enter the above formula I'm getting the following error;

"You've entered too many arguments for this function."

 

[njimack]

Oops! That'll teach me to test my formulae in Excel rather than typing it straight into here. This version should work for you...
=TEXT(DATE(YEAR(TODAY()),A4,1),"mmmm")

 

[barry houdini]

Try this formula

=TEXT(A4*29,"mmmm")

 

[njimack]

Try this formula

=TEXT(A4*29,"mmmm")

I can't believe I've never thought of this!

 

[BrianHall]

Neil & Barry,

Thank you very much. It works perfectly now.

Have a great day..

Regards,

Brian