D
Dianethetech
I am trying to get information using a date.
A B C D
04/28/06 64 1 0
I wrote =IF(A2>27,B2,C1)
A B C D
04/28/06 64 1 0
I wrote =IF(A2>27,B2,C1)
Teethless mama said:Try this:
=IF(DAY(A2)>27,B2,C1)