Thread: Return Month & Year of Date Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WildWill WildWill is offline
external usenet poster
  
Posts: 64
Default 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!
Reply With QuoteReply With Quote