ExcelBanter - Split month in half

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

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

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

Split month in half

Hi,

I am using the following formula to put in value if it is in the
month.

IF(AND(P$4=DATE(YEAR($AR13),MONTH($AR13),1),P
$4<=DATE(YEAR($AS13),MONTH($AS13)+1,0)),"have","fr ee")

What I would like to do is to be able to split the month in half and
put the value if it is before the 16th of month and if it after the
16th.

Any ideas?

Thanks.

PS. If you have seen this post before, it is because I can't seem to
find it. I have searched for it, still no luck.

Split month in half

If your date is in cell B13 try this:
=IF(DAY(B13)<16,"have","free")

"AlanStotty" wrote:

Hi,

I am using the following formula to put in value if it is in the
month.

IF(AND(P$4=DATE(YEAR($AR13),MONTH($AR13),1),P
$4<=DATE(YEAR($AS13),MONTH($AS13)+1,0)),"have","fr ee")

What I would like to do is to be able to split the month in half and
put the value if it is before the 16th of month and if it after the
16th.

Any ideas?

Thanks.

PS. If you have seen this post before, it is because I can't seem to
find it. I have searched for it, still no luck.