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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement with dates 0
NESTED ANDIF STATEMENTS 1
Multiple if statements 5
if statement with date format 2
Column value for row = fiscal quarter (determined by date field) 4
If statement with non specific date 7
If Statement 5
Date in "If" formula 5

Back
Top