What is the syntax to check if a date occurred before a referance.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to check a column of dates against a reference date to determine
if the dates occurred before the reference date. I am using the following
logical expression:

IF(A1<"01-Jan-2004", "True","False")

column A contains dates like:

01-Feb-2004

The expression provides the correct answer for some dates and the incorrect
answer for others. Anyone know the correct syntax for this expression?
 
that looks like it should work. it may help if you convert your date format
to a fully numeric one eg 01/02/04 as the formula you have used may not be
able to parse alphanumeric data
 
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

subtracting dates in an IF statement 2
Identify occurences that occur after a date but not before 1
Excel check if dates are under a range of week 4
Autoincrementing dates 5
How to select the date? 4
Access Property sheet data missing also syntax 0
Logical Test on Date value 1
Date Comparison Formula 1

Back
Top