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

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

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

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

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 -