ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cannot bring out the month & year from a date (https://www.excelbanter.com/excel-worksheet-functions/450832-cannot-bring-out-month-year-date.html)

San[_4_] April 29th 15 10:34 AM

Cannot bring out the month & year from a date
 
Hi

I would like to bring out the month from a given date in the format 'mmm-yy'. The original date is in dd/mm/yyyy format.

But when I am using the Month function with format "mmm-yy", it is giving an erratic result.

Say for example,


A2 B2

15/04/2015 =MONTH(A2) Result = Jan-00


Why is this happening?

regards

San

Claus Busch April 29th 15 11:35 AM

Cannot bring out the month & year from a date
 
Hi San,

Am Wed, 29 Apr 2015 02:34:57 -0700 (PDT) schrieb San:

I would like to bring out the month from a given date in the format 'mmm-yy'. The original date is in dd/mm/yyyy format.


Method1:
In B2 write =A2 and format the cell custom with MMM-YY
Method2:
In B2 use =TEXT(A2,"MMM")&"-"&TEXT(A2,"JJ")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Claus Busch April 29th 15 11:41 AM

Cannot bring out the month & year from a date
 
Hi again,

Am Wed, 29 Apr 2015 12:35:47 +0200 schrieb Claus Busch:

In B2 use =TEXT(A2,"MMM")&"-"&TEXT(A2,"JJ")


sorry, that is the german format
Try:
=TEXT(A2,"MMM")&"-"&TEXT(A2,"YY")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

San[_4_] April 29th 15 01:28 PM

Cannot bring out the month & year from a date
 
On Wednesday, April 29, 2015 at 4:11:16 PM UTC+5:30, Claus Busch wrote:
Hi again,

Am Wed, 29 Apr 2015 12:35:47 +0200 schrieb Claus Busch:

In B2 use =TEXT(A2,"MMM")&"-"&TEXT(A2,"JJ")


sorry, that is the german format
Try:
=TEXT(A2,"MMM")&"-"&TEXT(A2,"YY")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


Thanks Claus.. That worked

San


All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com