| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split by half month
Hi,
This formula works fine if you want to put in the values if it is in a month: IF(AND(P$4=DATE(YEAR($AS6),MONTH($AS6),1),P $4<=DATE(YEAR($AT6),MONTH($AT6)+1,0)),"have","free ") What I would like to do now is split the month in to 2. The first half and then the second half. Any ideas how I can do that? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split by half month | 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) | |||
Threaded Mode
