Thread: convert dates to month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default convert dates to month
with the value in A1 use:

=DATE(RIGHT(A1,4),--MID(A1,4,2),1) and format as mmmm,yyyy
--
Gary''s Student - gsnu200809


"Mati" wrote:

Need help to convert format "26.01.2008" to "January,2008". I have tried
formatting under dates etc and unfortunately it does not work.
Thanks,
Mati
Reply With QuoteReply With Quote