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.