Return previous month and current month in text cells.

[DarkSoul]

EDIT: I FIGURED IT OUT


I have a cell that I want to show the previous month, but to also contain text before the month.

I was going to use this but not sure if I can because it only returns the month and I don't know how to add text to it lol

=TEXT(TODAY()-DAY(TODAY()),"MMMM") so the cell would say "for the month of =TEXT(TODAY()-DAY(TODAY()),"MMMM")"


I need to do the exact same thing in a different cell, except for the current month instead of the previous month.

Is this possible somehow?