Return Month & Year of Date Value

  • Thread starter Thread starter WildWill
  • Start date Start date
W

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!
 
=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
 
Back
Top