Split by half month

[AlanStotty]

Hi,

This formula works fine if you want to put in the values if it is in a
month:
IF(AND(P$4>=DATE(YEAR($AS6),MONTH($AS6),1),P
$4<=DATE(YEAR($AT6),MONTH($AT6)+1,0)),"have","free")

What I would like to do now is split the month in to 2. The first
half and then the second half. Any ideas how I can do that?

Thanks.

 

[Guest]

Add a test for dates for days 1-15 and >15 to month end?