excel month formula

[bensonsearch]

HI All,

I have the following formula

MONTH(NOW())

however this returns for eg 10 for Oct.

is there anyway of changing this to return Oct instead of 10?

 

[Sal Paradise]

=CHOOSE(MONTH(NOW()),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

 

[T. Valko]

HI All,

I have the following formula

MONTH(NOW())

however this returns for eg 10 for Oct.

is there anyway of changing this to return Oct instead of 10?

Try this...

=TEXT(NOW(),"mmm")

 

[bensonsearch]

awesome thanx, now one last question in the below vlookup how do I get the formula to combine this result with a constant? (in this case ' 11')

=VLOOKUP(A1,(CHOOSE(MONTH(NOW()),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") &' 11'!A1:B2),2,FALSE)

 

[T. Valko]

awesome thanx, now one last question in the below vlookup how do I get the formula to combine this result with a constant? (in this case ' 11')

=VLOOKUP(A1,(CHOOSE(MONTH(NOW()),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") &' 11'!A1:B2),2,FALSE)

So the month name represents a sheet name?

Like this...

=VLOOKUP(A1,INDIRECT("'"&TEXT(NOW(),"mmm")&" 11'!A1:B2"),2,0)

 

[bensonsearch]

yes it does, but only wish to have it variable between months (hence the call to month) thanx heaps worked great

 

[T. Valko]

yes it does, but only wish to have it variable between months (hence the call to month) thanx heaps worked great

You're welcome. Thanks for the feedback!

 

[Sal Paradise]

Try this...

=TEXT(NOW(),"mmm")

Your simplicity makes me feel inadequate. I should have thought of that.