ExcelBanter - Split by half month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Split by half month (https://www.excelbanter.com/excel-discussion-misc-queries/134590-split-half-month.html)

AlanStotty

Split by half month

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.

Toppers

Split by half month

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

"AlanStotty" wrote:

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.

All times are GMT +1. The time now is 08:29 AM.