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!

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!