I need to validate a date field. Consider, Date1 field will be empty initially. When user enter any date it should be future date. When I tried with Column Validation - it validates at empty state too.. How can I do this?

  • paste the Formulas you tried Feb 16, 2016 at 13:39
  • @DannyEngelman pls check the updated question again
    – Arun
    Feb 16, 2016 at 14:11

1 Answer 1


How about

=AND(   NOT(ISBLANK([Date1]))   ,   [Date1]>Today()   )

When you say "it validates at empty state too", do you mean you want it to accept an empty date?

Then use

=OR(   ISBLANK([Date1])   ,   [Date1]>Today()   )
  • its Not Working
    – Arun
    Feb 17, 2016 at 6:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.