| 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. |
| 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 | |||
Threaded Mode
