Hi, I'm looking for a formula that will pick and return the name or number of the month that will come next from a list of months, without using a helper column if possible.

So the formula should contain the list of months, pick the one that will come next, and display it.

Suppose the list of months is March and September. From 1st April to 30th September, the formula should return September. From 1st October to 31st December, and from 1st January to 31st March, it should return March.

Suppose the list of months is January, April, July and October. During February, March and April, it should return April. During May, June and July it should return July. During August, September and October, it should return October. During November, December and January, it should return January.

The year is irrelevant.

Any ideas?
Thank you!