Month format issue

**mariec_06** · 10-07-2016, 04:21 AM

I have the following formula in a worksheet which works just fine and give me the Today month -1 in format "mmm" I.e Aug. Here is the formula

TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,),"MMM")

I need to have the same result in Vba. Can someone assist?

I have tried MONTH(TODAY) - 2 but obviously I got "Jan"....

**alansidman** · 10-07-2016, 04:28 AM

try this:

Please Login or Register  to view this content.

Month format issue

LinkBack

Thread Tools

Rate This Thread

Display

Month format issue

Re: Month format issue

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Month format issue - convert 9/1/2013 into Sep

[SOLVED] issue with =day(a1) & =month(a1)

[SOLVED] IF statement to read month format and place month name in next cell

Automatically format only those month-cells, that are 3 months ahead of chosen month

Auto Format spreadsheet with various rows month to month

[SOLVED] If(And(Month() Issue

[SOLVED] how do i change the format for excel to day-month:as day-month.

Date Format - converting number of month to name of month

Bookmarks

Bookmarks

Posting Permissions