A
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.
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.