| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count months away betwwen a strat and end date by month | Excel Worksheet Functions | |||
| Month to date calculations | Excel Worksheet Functions | |||
| Formula = Today's date + 1 month | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Linear Mode
