| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Months by looking at the dates
I have a column with dates like 01/01/07 , 02/15/07 etc.
Is there any way to create a formula in the next column to display month like JAN-07 , FEB-07 etc. I would really appreciate help. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display Months by looking at the dates
One way:
A1: 01/01/07 B1: =A1 Format B1 as mmm-yy. Or, if you want a text string (not an XL date): B1: =TEXT(A1,"mmm-yy") In article . com, " wrote: I have a column with dates like 01/01/07 , 02/15/07 etc. Is there any way to create a formula in the next column to display month like JAN-07 , FEB-07 etc. I would really appreciate help. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display Months by looking at the dates
Hi
With date in A1, in A2 =A1 FormatCellsNumberCustom mmm-yy Copy down as far as required Alternatively if you want a text value (instead of the value remaining as a serial date number but formatted to show your desired result, then use =TEXT(A1,"mmm-yy") -- Regards Roger Govier wrote in message ups.com... I have a column with dates like 01/01/07 , 02/15/07 etc. Is there any way to create a formula in the next column to display month like JAN-07 , FEB-07 etc. I would really appreciate help. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display Months by looking at the dates
=TEXT(A1,"mmm-yy")
or =A1 (format cell as mmm-yy) " wrote: I have a column with dates like 01/01/07 , 02/15/07 etc. Is there any way to create a formula in the next column to display month like JAN-07 , FEB-07 etc. I would really appreciate help. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display Months by looking at the dates
Thanks you very much ,
It was a great help. On Jan 19, 2:18 pm, Teethless mama wrote: =TEXT(A1,"mmm-yy") or =A1 (format cell as mmm-yy) " wrote: I have a column with dates like 01/01/07 , 02/15/07 etc. Is there any way to create a formula in the next column to display month like JAN-07 , FEB-07 etc. I would really appreciate help. Thanks- Hide quoted text -- Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can autofill, as in months or dates, go to the end of the spreads | Excel Worksheet Functions | |||
| Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
| SUMIF for Dates / Months ? | Excel Worksheet Functions | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Converting Text months to sortable Numbers or Dates | Excel Discussion (Misc queries) | |||
Linear Mode
