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 |
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 |
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 |
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 08:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com