VBA Code for name of previous month

vba date monthcalendar
wasimakram101 picture wasimakram101 · Apr 27, 2017 · Viewed 12k times · Source

I have added text in to my email that goes like:

"please provide numbers for MMMM month end" - where MMMM is the name of the previous month.

So it it's April today, MMMM will show March.

I have the following code:

Dim newDate: newDate = DateAdd("M", -1, Now)

But the result comes out to be 27/03/2017 16:37:58

I want it to show March.

Any suggestions?

Answer

Scott Craner picture Scott Craner · Apr 27, 2017

Format the return as "MMMM":

Dim newDate: newDate = Format(DateAdd("M", -1, Now), "MMMM")

Related questions

Autofilter with column formatted as date

I am using an AutoFilter with VBA in Excel that works for regular filters, but not a column formatted as date. I can filter it manually. If I run my code, it filters nothing but when I check the filter …

Read More
How to find the difference between dates in VBA

I am trying to find out the difference between the system date and the date stored in the worksheet. If the difference between them is > 30 days, the result is true, else the result is false Dim result as boolean …

Read More
SQL Query between dates in VBA

I've a problem making a sql query in VBA using excel and an access database. In mi VBA code I've two data variables with this content: DateMin = 31/07/2014 22:00:00 DateMax = 01/08/2014 06:00:00 And I have an access database with many data with a date …

Read More