Get month from date
 

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

Get month from date
 

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

--
Kind regards,

Niek Otten

wrote in message
oups.com...
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

Get month from date
 

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

MsgBox MonthName(Month(Date))

(I think xl2k added MonthName...)

wrote:

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

--

Dave Peterson