View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AlanStotty AlanStotty is offline
external usenet poster
 
Posts: 17
Default 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.