Hi,

Have a look at the other responses you can check for = in 1 go.

Mike

"trip_to_tokyo" wrote:


Cell C 1 is formatted as a date.

Cell AB2 is formatted as a date.

The formula in AB6 is:

=IF(OR(AB2C1,AB2=C1),B2,"0")

I think that the above gives you what you want.

If my comments have helped please hit Yes.

Thanks.


"BBABBZZ" wrote:

HELP!!!

=IF(AB2, C1 THEN B2)

C1 IS A DATE....IF AB2 IS GREATER THAN OR EQUAL TO THAT DATE THEN INSERT
AMOUNT IN B2, IF NOT ENTER "0"