If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|