IF Statement with Dates.

  • Thread starter Thread starter cjwenngatz
  • Start date Start date
C

cjwenngatz

As part of a method to try and create a summary sheet, I have an IF
statement setup to tell me the date period. Currently, it states:
=IF('OC''s'!I3>5/5/2007,1,0)

Basically state "1" if the date is greater than May 5, 2007. For some
reason, it responds with a "1" anytime there is anything written into
the cell, which is driving me nuts. Also, what would I do if I want to
have it populate a "1" if the date in that cell is between May 5th and
May30th?

Thanks!
 
Your 5/5/2007 is being interpreted as 5 divided by 5 divided by 2007,
so almost any date will be greater then the result. Replace it by
DATE(2007,5,5)
 
Your 5/5/2007 is being interpreted as 5 divided by 5 divided by 2007,
so almost any date will be greater then the result. Replace it by
DATE(2007,5,5)
Click to expand...

Perfect! Thank you very much!
 
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

Arithmetic with Cell Dates 1
Dynamic Offset from an Application.Goto cell = Date or Time 10
simple IF statement 5
If statement with dates 0
Unexpected result from IF statement... Help with formula. 3
calculating difference between date/time fields 19
Comparing date values 2
Re training expiry date formula required 3

Back
Top