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
|