1. Home
2. Questions
3. Tags
5. Users
6. Jobs
7. Companies
8. Unanswered
Teams

Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Try Teams for free Explore Teams
Teams
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Return to Answer

added 36 characters in body

Source Link

edited Nov 9, 2018 at 2:19

The calculated column formula as below.

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

The calculated column formula as below.

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

The calculated column formula as below.

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

Source Link

created Nov 9, 2018 at 1:48

The calculated column formula as below.

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