#1   Report Post  
Posted to microsoft.public.excel.misc
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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 184
Default Split month in half

If your date is in cell B13 try this:
=IF(DAY(B13)<16,"have","free")

"AlanStotty" wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split by half month AlanStotty Excel Discussion (Misc queries) 1 March 13th 07 01:24 PM
Split by half month AlanStotty Excel Discussion (Misc queries) 2 March 13th 07 01:08 PM
How to split (half) one cell w/o changing col or rows. Landy2130 Excel Discussion (Misc queries) 11 December 29th 06 08:44 PM
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW? Blondie Excel Discussion (Misc queries) 4 October 10th 06 03:52 AM
Countif that can i half Joel Excel Discussion (Misc queries) 1 January 5th 06 09:18 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"