Return Month & Year of Date Value

[WildWill]

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!

 

[Peo Sjoblom]

=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