Amend code to show previous month

I have the following code below

Please Login or Register  to view this content.

It returns the following :

Attached please find summary sales as at January 2018 vs the Prior Year



I would like it to show the month and year relating to the previous month i.e 30 days less than the current month for eg if the current month is January 2018 it must return


Attached please find summary sales as at December 2017 vs the Prior Year



It would be appreciated if someone could kindly amend my code

There is no attachment. I should have been clearer


The text should read for eg "Attached please find summary sales as at December 2017 VS Prev Year" by amending the code to be 30 days less than the current month for eg if Current month is January 2018, that month and year to be Dec 2017

Suggest:
Formula:

Please Login or Register  to view this content.

or
VBA

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Guys


Thanks for the help. Your codes work perfectly