| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split by half month
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split by half month
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. "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you fill only half of a cell | Excel Discussion (Misc queries) | |||
| Replacing half a formula | Excel Discussion (Misc queries) | |||
| How to split (half) one cell w/o changing col or rows. | Excel Discussion (Misc queries) | |||
| HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW? | Excel Discussion (Misc queries) | |||
| Countif that can i half | Excel Discussion (Misc queries) | |||
Linear Mode
