Using Dates in an If Statement

  • Thread starter Thread starter Brenda
  • Start date Start date
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!
 
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)
 
Back
Top