• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Problem with IF statement

The below IF statement is not working as I need it to be


What I need to do is check the date in H2 and if it is less than 10/29/2012 then return Pre, else return Post.
The date formating for H2 = xx/xx/xxxx
Frank Freese
Frank Freese
2 Solutions
barry houdiniCommented:
10/29/2012 won't be recognised as a date like that,  try either


or better to use unambiguous DATE function like this


regards, barry
Frank FreeseAuthor Commented:
both great answers
thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now