Thread: Extract Month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Extract Month

Hi guys, Looking for a way to extract the month from the following
date....

01/03/2007 00:00
I need the formula to pull out the month ( 03 ) and give it it's name ,,
as
in March for 03 ,, can this be done ?


Give this formula a try...

=TEXT(A1,"mmmm")

where your date is assumed to be in A1.

Rick