Calculating using a date

D

Diane

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(A2>27,B2,C2)

Thanks in advance of any help anyone can give me.
 
D

Dianethetech

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
 
C

CLR

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
 
Top