Get month from date

[RobcPettit]

Useing VBA, how to I get the month from a date in range("a1") as text.
Eg if date = 30/1/02, Month = "January" or 30/10/05 then month =
"October". I want to worksheets with the month.
Regards Robert

 

[Niek Otten]

MonthA = format(range("a1"),"mmmm")

 

[Dave Peterson]

Another way, depending on what version of excel you're using:

MsgBox MonthName(Month(Date))

(I think xl2k added MonthName...)