Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Month and year from Cell containing date, month, year & time | Excel Worksheet Functions | |||
Date(Year,Month,Day) not returnign correct date | Excel Discussion (Misc queries) | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) |