ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get Month from date (https://www.excelbanter.com/excel-programming/273800-re-get-month-date.html)

Guido[_2_]

Get Month from date
 
strMonth = CHOOSE(MONTH("04.02.2003"),"January","February","M arch","April"
....)

Guido

HoloGuides
http://hologuides.com/programming/ExcelVBA


"Pedro" schrieb im Newsbeitrag
...
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 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com