| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Month & Year of Date Value
Hi
In cell A1, I have a date value formatted as "12 January 2008", in cell B1 I want to display the Month & Year part of the date in A!, e.g. "Janunary 2008". What formula can i use to achieve this? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return Month & Year of Date Value
=TEXT(A1,"mmmm yyyy")
or just link to A1 =A1 and use custom format mmmm yyyy This assumes that the date in A1 is read as an excel date, that the underlying value if you format it as general is 39459 -- Regards, Peo Sjoblom "WildWill" wrote in message ... Hi In cell A1, I have a date value formatted as "12 January 2008", in cell B1 I want to display the Month & Year part of the date in A!, e.g. "Janunary 2008". What formula can i use to achieve this? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| Need cell formulas to return the day of every Monday in a month based on year entered | Excel Discussion (Misc queries) | |||
| Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))' | Excel Worksheet Functions | |||
Hybrid Mode
