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.