Display the month that will come next from a list of months

[ricrp]

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!

[zbor]

Try this formula (with numbers):

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[windknife]

Another method,

Please Login or Register  to view this content.

[HansDouwe]

A third option: Please try in G1 and copy down:

Please Login or Register  to view this content.

[ricrp]

Thanks a lot! All options work perfectly!!

[HansDouwe]

You are Welcome!

Thanks for your feedback, Glad to have helped. .

If you haven't already, please consider adding reputation to all helpers you think they deserve.
In that case please click * Add Reputation left below their answers.

[windknife]

You are welcome.