Using Dates in an If Statement

B

Brenda

What do I have to do have the following If statement
recognize the date. It is not working as scripted below.

IF(A3<10/7/2002,1.07,0)

Thanks in advance for your feedback!
 
P

Paul

Brenda said:
What do I have to do have the following If statement
recognize the date. It is not working as scripted below.

IF(A3<10/7/2002,1.07,0)

Thanks in advance for your feedback!
Click to expand...

Either
=IF(A3<DATEVALUE("10/7/2002"),1.07,0)
or
=IF(A3<DATE(2002,7,10),1.07,0)
 
Top