MONTH/DATE (IFS) formula

[AliciaGoyanes]

Hello,

I have a doubt regarding Excel.

I want to change months every time I pass the 25th day of the previous month.

For example, if it today were to be 26th October, (using the formula TODAY()) I would like to obtain with another formula the next month ("NOV"). It must stay in "NOV" until I reach the 26th of November, and then I would get "DEC" as a result of the formula.

The months I have them in an index, being them in column A5. They stay as:
A5= "NOV"
A6="DEC"
A7="JAN"
.
.
.

Thanks a lot!

 

[AliciaGoyanes]

Maybe

=INDEX(A3:A6,MONTH(A2)-8+(DAY(A2)>25))

Hi Fluff, for the first month it does work, however, if I drag down the formula, it is always giving the same month. What it should give is the index as it shows when I drag down the formula.

If its very confusing I can try to include a mini sheet.

 

[Fluff]

Sorry but I have no idea what you are trying to do.