Day range to name as month

[Reon35]

[TABLE="width: 533"]
<colgroup><col span="2"><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 4"]Condition for the Month column:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 8"]>IF DATE/DAY IS 1-15, MONTH TO APPEAR ON MONTH COLUMN IS CURRENT MONTH

[/TD]
[/TR]
[TR]
[TD="colspan: 8"]>IF DATE/DAY IS 16-31, MONTH TO APPEAR ON MONTH COLUMN IS FOLLOWING MONTH[TABLE="width: 533"]
<colgroup><col span="2"><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 4"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 8"]Hopefully someone can help me. Thanks[/TD]
[/TR]
[TR]
[TD="colspan: 8"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[estevaoba]

Assuming date in A2, try this in B2 and copy down:

=IF(A2<=DATE(YEAR(A2),MONTH(A2),15),MONTH(A2),MONTH(A2)+1)

 

[mrshl9898]

First reply returns 13 for 17/12/2016.

Try this:

=IF(DAY(A1)<16,TEXT(A1,"mmmm"),TEXT(IF(MONTH(A1)+1=13,1,TEXT(DATE(YEAR(A1),MONTH(A1)+1,1),"mmmm")),"mmmm"))

 

[Tetra201]

A bit shorter:

=TEXT(EDATE(A2,--(DAY(A2)>15)),"mmmm") for month names
=MONTH(EDATE(A2,--(DAY(A2)>15))) for month numbers

 

[Reon35]

Thanks mrshl9898, it worked!!! ​

 

[Reon35]

Thanks Tetra21, it worked too!!!