Change month name in text field

[ppatane]

How can I change the month name in a description to the next month? In this example, get all the April words to be May, and have it work every month.

[Raj]

@ppatane one way is writing a formula with multiple iffs and elseifs
another way is using Find and replace tool.

[binu_acs · Accepted solution]

@ppatane one way of doing this

[ppatane]

Wow, incredibly complex Regex statement, and it even goes forward a year for December to January.  Perfect!  Grazie!