Split by half month

A

AlanStotty

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

Guest

The 1 at the end of this statement says to compare datte against the 1st of
the month. MONTH($G5),1

change the 1 to a 15 to compare with the 15th of the month.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fomula only half working 8
Convert Text to Date Month and Year 1
Split by half month 1
Convert date field to month in Pivot table 9
Split month in half 1
Tricky Scenario finding days/months/years! 3
Specific Date from a Range 3
MONTH display 6

Top