1

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?

1

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")
|improve this answer|||||
0

Try below formula.

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

enter image description here

enter image description here

|improve this answer|||||
0

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".
|improve this answer|||||

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.