return month from a date
 

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
--
Brevity is the soul of wit.

return month from a date
 

=TEXT(A1,"mmm")
--
Gary's Student


"Dave F" wrote:

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
--
Brevity is the soul of wit.

return month from a date
 

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

--
Don Guillett
SalesAid Software

"Dave F" wrote in message
...
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
--
Brevity is the soul of wit.

return month from a date
 

Thanks.
--
Brevity is the soul of wit.


"Gary''s Student" wrote:

=TEXT(A1,"mmm")
--
Gary's Student


"Dave F" wrote:

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
--
Brevity is the soul of wit.

return month from a date
 

Thanks.
--
Brevity is the soul of wit.


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Dave F" wrote in message
...
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
--
Brevity is the soul of wit.

return month from a date
 

You are very welcome !
--
Gary's Student


"Dave F" wrote:

Thanks.
--
Brevity is the soul of wit.


"Gary''s Student" wrote:

=TEXT(A1,"mmm")
--
Gary's Student


"Dave F" wrote:

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
--
Brevity is the soul of wit.

return month from a date
 

Why bother with TEXT. Use =A1 and use custom format "mmm"
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
=TEXT(A1,"mmm")
--
Gary's Student


"Dave F" wrote:

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
--
Brevity is the soul of wit.