Calculating using a date
 

I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date.

A B C
4/28/06 64 1

This is what I wrote, but it's not capturing the date the correct way.

If(A227,B2,C2)

Thanks in advance of any help anyone can give me.

Calculating using a date
 

Try this...........

=If(DAY(A2)27,B2,C2)

Vaya con Dios,
Chuck, CABGx3




"Diane" wrote:

I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date.

A B C
4/28/06 64 1

This is what I wrote, but it's not capturing the date the correct way.

If(A227,B2,C2)

Thanks in advance of any help anyone can give me.

Calculating using a date
 

Thank you so much, that works perfectly.
--
DMM


"CLR" wrote:

Try this...........

=If(DAY(A2)27,B2,C2)

Vaya con Dios,
Chuck, CABGx3




"Diane" wrote:

I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date.

A B C
4/28/06 64 1

This is what I wrote, but it's not capturing the date the correct way.

If(A227,B2,C2)

Thanks in advance of any help anyone can give me.

Calculating using a date
 

That solves one problem, now I need to know how I can say
=If(DAY(A2)27,B2,C2)AND B2 IS < 2 THEN B2 IF NOT MAKE IT BLANK
DMM


"CLR" wrote:

Try this...........

=If(DAY(A2)27,B2,C2)

Vaya con Dios,
Chuck, CABGx3




"Diane" wrote:

I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date.

A B C
4/28/06 64 1

This is what I wrote, but it's not capturing the date the correct way.

If(A227,B2,C2)

Thanks in advance of any help anyone can give me.

Calculating using a date
 

Not real sure I understand your conditions, but give this a try...

=IF(B2=2,"",IF(AND(DAY(A2)27,B2<2),B2,C2))

Vaya con Dios,
Chuck, CABGx3


"Dianethetech" wrote:

That solves one problem, now I need to know how I can say
=If(DAY(A2)27,B2,C2)AND B2 IS < 2 THEN B2 IF NOT MAKE IT BLANK
DMM


"CLR" wrote:

Try this...........

=If(DAY(A2)27,B2,C2)

Vaya con Dios,
Chuck, CABGx3




"Diane" wrote:

I am trying to write an if statement to grab a certain cell if a date is 5
and the # in cell e2 is <4. I am having trouble getting the date.

A B C
4/28/06 64 1

This is what I wrote, but it's not capturing the date the correct way.

If(A227,B2,C2)

Thanks in advance of any help anyone can give me.