Date to month on a specific date

[mickeystanford_alumni]

Hi everyone,

I am trying to find a formula that gives me the month in a format =TEXT(A1,"MMM")
Where A1 is =TODAY() --> 15.09.2022.

In this case, it would give us SEP. However, I want to tell excel that if the day on the month is before the 15th, so from 1st-14th then to report SEP, but if day is on the 15th or after, to report OCT (so the month after).

Could you provide any guidance?

Thank you!

 

[Peter_SSs]

Try

=TEXT(DATE(1,MONTH(A1)+(DAY(A1)>14),1),"MMM")

 

[mickeystanford_alumni]

Hi Peter, thank you for the prompt response. It is perfectly working.
What if I would like to drag down the formula:
A2=TEXT(DATE(1,MONTH(A1)+(DAY(A1)>14),1),"MMM")
A3= ? (NOV)
A4= ? (DEC)

 

[Peter_SSs]

A2 & copy down:

=TEXT(DATE(1,MONTH(A$1)+ROWS(A$2:A2)*(DAY(A$1)>14),1),"MMM")

Or, if you wanted say 12 rows of this, just put this in A2 and no need to copy down

=TEXT(DATE(1,MONTH(A1)+SEQUENCE(12)*(DAY(A1)>14),1),"MMM")

 

[mickeystanford_alumni]

Hi Peter, great help.
I am actually complicating this a bit more, basically I do not want all the months 1 by 1, but want to tell the formula to skip some months. It would look like:
OCT
NOV
DEC
FEB
APR

So basically trying to create an index here. Is there any way that with the formula above, I just make a manual formula for each month linked to the first one, so I create the index there?

Let me know if clear...and thank you so much again.

 

[Peter_SSs]

Let me know if clear

It is not clear to me. How do we know
- How many moth names to produce?
- Which months to include?
- Which months to skip?