Thread: Extract Month
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John Moore John Moore is offline
external usenet poster
 
Posts: 70
Default Extract Month

Guys,

Thanks ,, works a treat ,,, Cheers
"FSt1" wrote:

hi,
date in a1....
=text(a1,"mmmm")

regards
FSt1

"John Moore" wrote:

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 ?