Split by half month
See previous posting
"AlanStotty" wrote:
Hi,
I am using this formula to calculate if go-live is in a paricular
month.
=IF(AND(S$4=DATE(YEAR($G5),MONTH($G5),1),S
$4<=DATE(YEAR($G5),MONTH($G5)+1,0)),"go-live","")
What I would like to do now is split the month in half. I want to work
out which half of the month the go-live is in.
e.g. So the first cell will be 01/03/07 to 15/03/07 and the second
cell will be 16/03/07 to 31/03/07. The same for each of the other
months.
Thanks in advance for your help.
|