Extract Month Name from Date in VBA

**vikas_newports** · 11-23-2020, 05:07 PM

Hello
How Can I extract the month name (e.g NOV) from today date in vba
for example, I want to Extract the month name from today date in Cell B1
In cell B2 "Salary" is already written
then how can I concatenate it as ( Nov Salary) in A1

appreciate if someone helps, thanks in advance

**TMS** · 11-23-2020, 05:17 PM

Try

Please Login or Register  to view this content.

**alansidman** · 11-23-2020, 05:22 PM

Please Login or Register  to view this content.

Edit: Trevor types faster!

**TMS** · 11-23-2020, 05:56 PM

@Alan: yes, but I got the cell reference wrong. Should be B2, as you have put, rather than B1 (which we don't need)

Corrected:

Please Login or Register  to view this content.

**Rick Rothstein** · 11-23-2020, 06:21 PM

Originally Posted by alansidman

Please Login or Register  to view this content.

You can compact this line of code by eliminating the concatenation of the space character and embedding the space in the pattern string directly...

Please Login or Register  to view this content.

I would note two things though...

1) The OP seemed to indicate he wanted the abbreviated month name, so your "mmmm" should probably be "mmm".

2) The OP seemed to indicate he wanted the abbreviated month name in all caps.

Taking both of these into account, I would suggest changing your code line to this...

Please Login or Register  to view this content.

**TMS** · 11-23-2020, 06:41 PM

@Rick: But then

... then how can I concatenate it as ( Nov Salary) in A1

**Rick Rothstein** · 11-23-2020, 06:53 PM

@TMS: Good point (missed that)! With the original post and my post, the OP should be able to figure out how to make the month name abbreviation display however he wants.

**TMS** · 11-23-2020, 07:11 PM

@Rick: yes, he has a range of options to choose from.

However, the one thing we have all been consistent about is the structure of the code and the function to use. Can't say fairer than that

.

I must admit that I always forget about using Format to add spaces

**vikas_newports** · 11-24-2020, 06:22 AM

thanks all for the various options ... problem resolved

**TMS** · 11-24-2020, 03:07 PM

You're welcome. Thanks for the rep.

Extract Month Name from Date in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Re: Extract Month Name from Date in VBA

Thread Information

Users Browsing this Thread

Similar Threads

I can't get the Month to extract from a date

[SOLVED] Extract month from date, have it display as 'Jan', and have excel read it as a month.

[SOLVED] Extract Year, Month, Day from date

Extract Year, Month, Day from date

Extract birthday date and month

Extract Month from date IE 3/10/2010 = 3

extract the month of a date

Bookmarks

Bookmarks

Posting Permissions