Day range to name as month

[Reon35]

Condition for the Month column:
>IF DATE/DAY IS 1-15, MONTH TO APPEAR ON MONTH COLUMN IS CURRENT MONTH
>IF DATE/DAY IS 16-31, MONTH TO APPEAR ON MONTH COLUMN IS FOLLOWING MONTH Hopefully someone can help me. Thanks <colgroup><col span="2"><col><col><col><col span="3"></colgroup><tbody> </tbody>

<colgroup><col span="2"><col><col><col><col span="3"></colgroup><tbody>
</tbody>

 

[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!!!