I have a list with two date columns:

1) Expiration Date

2) Today's Date

I'd like for the third column (Status) to produce this calculation:

  1. Today's date is equals/greater than Expiration date =Expired;
  2. when Today's Date < Expiration=Valid

Can someone write an if statement for this?

3 Answers 3


Unless you are using the "Today's Date" column somewhere else in your application, you could eliminate adding one extra field by using out of the box Today() function directly in the formula.

=IF(Today()>=[Expiration Date],"Expired","Valid")

Try below formula.

=IF([Today's Date]>=[Expiration Date],[Expiration Date],[Today's Date])

enter image description here

enter image description here


Follow below steps:

  1. Go to the list settings.
  2. Create new calculated field with name "Status".
  3. Use below formula in formula section:

    =IF([Today's Date]>=[Expiration Date],"Expired","Valid")

  4. Return data type from this formula as "Single line of text".
  • Have you tried this? Jan 16, 2019 at 6:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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