I am trying to create a calculated column based on a date comparison. This should be a simple if else block condition but its driving me nuts. I have a date column called "Expiration Date" and I am trying to add a calculated column as follows: If the Expiration date value matches today's date then calculated column value will be "Expired" else "Valid".

Can someone please help me out with the formula,thanks in advance.

1 Answer 1


The calculated column formula as below.

=IF(ISBLANK([Expiration Date]), "", If([Expiration Date]<=Now()+1,"Expired","Valid"))

enter image description here

  • 1
    Thanks so much, one issue I am seeing is, in a scenario when Expiration date column is null then also calculated field shows value as Expired, in theory if expiration date is null then calculated column should also be left blank. Can you help?
    – mdevm
    Nov 9, 2018 at 2:02
  • I modify the reply above, check it.
    – LZ_MSFT
    Nov 9, 2018 at 2:21

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.