On Mar 5, 3:00 pm, bj wrote:
not really September 2 is not in the same month as January 1
So I am more confused as to what you need.

there are four options
A AG120=r4,AH120<=r4
B AG120<r4,AH120<=r4
C AG120=r4,AH120r4
D AG120<r4,AH120r4

with your current equation, only D would give a "Need" response
the others would give "".
your data would be in option C

whatr response do you need for each of the options?
and please explain more about your "within the month" comment



"AlanStotty" wrote:
On Mar 5, 2:16 pm, bj wrote:
Ag120 is greater than r4 ithe cell should populate with ""
what do you want it to do?

"AlanStotty" wrote:
Hi,

I am using the following calculation in the field:

=IF($AG120 =R$4, "", IF($AH120 <=R$4, "", "need"))

where AG120 = 23/01/2007, R4 = 01/01/2007 and AH120 = 02/09/2007.

But it does not seem to populate with "need".

Any ideas?- Hide quoted text -

- Show quoted text -

I want it to populate with "need" as it is within that month. Hope
that is clearer. :-)- Hide quoted text -

- Show quoted text -



I have put an example of what I want:


01/01/2007 01/02/2007 01/03/2007 01/04/2007
01/05/2007 FromDate ToDate
need need
need 12/02/2207
15/04/2007


As you can see if the date is within the month, I want to put need
otherwise leave blank. Hope this is clearrrrrrrrerrrrrr. :-)