Save file as "mmm-mmm yyyy"?

[gliori]

Hello,

I'm looking for help with, what I thought was a simple thing to do but apparently not for me, to save a file with the format "mmm" of the month 4 months ago, "mmm" of the month 1 month ago, followed by "yyyy" of current year.
So now in June it would be, "Feb-May 2019". Basically it's the latest quarter, so maybe there is a simplier way to do it?

This is what I have so far:

Please Login or Register  to view this content.

However, I get a "Compile Error: Expected Array" on this "month = Format(DateSerial(month(Date) - 1, 1), "mmm")". I'm not really a pro on this, so any help is appreciated!

Thanks in advance!

[Arkadi]

DateSerial needs 3 arguments (year, month, day)

So maybe:

Please Login or Register  to view this content.

[gliori]

DateSerial needs 3 arguments (year, month, day)

So maybe:

Please Login or Register  to view this content.

Hmm, aah OK, I still got the same error message even when I changed it though

[nigelog]

change you variables to mymonth,mymonth2,myyear

[Arkadi]

@nigelog good call.
@gliori avoid using any function names (or properties) for variables.

[davsth]

Im not sure how you get feb to may as that is 4 months not 3

I am also wary about using month as a name in vba anything that could be interpreted as something else

Try adding the below

Please Login or Register  to view this content.

[nigelog]

Ta, glad to help

[gliori]

Im not sure how you get feb to may as that is 4 months not 3

I am also wary about using month as a name in vba anything that could be interpreted as something else

Try adding the below

Please Login or Register  to view this content.

Thanks a lot, that was a very nice solution!

And of course, you're right, should be current month-3 and not 4, to current month-1.

With this code I got it completely right:

Please Login or Register  to view this content.

Thanks again all!