return month from a date

[Guest]

Given a date, say 11/12/2006, how can "Nov" be returned. I know =MONTH(A1)
would return 11 if 11/12/2006 is in A1. So I have a formula
=VLOOKUP(MONTH(A1),'Mth Lookup'!$A$1:$B$12,2,FALSE) which returns Nov if
MONTH(A1) = 11, and so on. But this seems rather cumbersome.

Is there a more direct way to do this?

Dave

 

[Guest]

=TEXT(A1,"mmm")

 

[Don Guillett]

why not just =text(yourlookupformula,"Mmm")

 

[Guest]

Thanks.
--
Brevity is the soul of wit.

=TEXT(A1,"mmm")

 

[Guest]

Thanks.
--
Brevity is the soul of wit.

why not just =text(yourlookupformula,"Mmm")

 

[Guest]

You are very welcome !
--
Gary's Student

Thanks.

 

[Bernard Liengme]

Why bother with TEXT. Use =A1 and use custom format "mmm"
best wishes