| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to get 1st,2nd,3rd,4th,5th Sundays from month end date. | Excel Discussion (Misc queries) | |||
| enter month end date | Excel Worksheet Functions | |||
| using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
| Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Linear Mode
