date function
 

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!

date function
 

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!

date function
 

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

date function
 

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!