ExcelBanter - Get Month from date

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get Month from date (https://www.excelbanter.com/excel-programming/273797-get-month-date.html)

AA2e72e

Get Month from date

Try:

format(strdate,"mmmm")

-----Original Message-----
Hi

I have the following code

Dim strDate as Date

strDate="30/06/2003"

I want strMonth to be the same month as the strDate. In
this example I want
the output of strMonth to be June
What code should I write to get it from the strDate?

Regards
Pedro

.

All times are GMT +1. The time now is 11:21 PM.