help pls.. how can I get the month of a whole date. example March 2, 2007.
should return only the Month which is March.Thanks!

Various ways:

Private Sub CommandButton1_Click()
Dim TheMonth As Long

TheMonth = Month(Now())
Debug.Print TheMonth
Debug.Print MonthName(TheMonth, False)
Debug.Print MonthName(TheMonth, True)
Debug.Print Format(Now(), "dd/mmmm/yyyy")
End Sub

NickHK

"Chinx21" . wrote in message
...
help pls.. how can I get the month of a whole date. example March 2, 2007.
should return only the Month which is March.Thanks!

If Cell A1 has the date. Write the following formual in any other
cell...
=TEXT((A1),"MMMM")
Now this cell will have the month.

Thx
Karthik

Hi,

and also
msgbox datepart("m",now)
msgbox monthname(datepart("m",now))
msgbox monthname(datepart("m","March 2, 2007"))

Look in help for the DatePart Function
Regards
JY

"Chinx21" . wrote in message
...
help pls.. how can I get the month of a whole date. example March 2, 2007.
should return only the Month which is March.Thanks!