Function to Output Current Month and Year

**cg0789** · 04-13-2012, 12:25 PM

I was wondering if there was a function which will output the the current month and year for example "April 2012" preferably "April_2012". I have tried using the Now() function and then formating another cell to MMMM_YYY but when I call that cell in VBA it outputs "4/13/2012 12:23PM" (full current time). Any idea on how to do this?

Thanks in advance!

**Bob Phillips** · 04-13-2012, 01:08 PM

Try

=TEXT(TODAY(),"mmmm_yyyyy")

**Leith Ross** · 04-13-2012, 01:12 PM

Hello cg0789 ,

VBA will always display a date according to the system's short date setting. You can use the VBA Format statement to change the output of the date. Here is an example

Please Login or Register  to view this content.

NOTE:
Internally, all dates are numbers. Excel and VBA allow the number output to be formatted in a way understood by people. The format statement returns a String and not a Date. Because this is custom date format, Neither Excel nor VBA will not be able to convert this string to date and can not be used with Date functions.