Forum Discussion
Status Change based on dates
I have a Share Point Online list which has employee details. An employee can work on 3 different projects at any given time. I need to be able to add a status column for their contracts. Test cas...
nniphadk Try using below formula for your calculated column (status):
=IF(AND([End Date 1] > Today(), [End Date 2] > Today(), [End Date 3] > Today()), "Expired", "Active")
OR
=IF(AND([End Date 1] > Now(), [End Date 2] > Now(), [End Date 3] > Now()), "Expired", "Active")
Documentation: Calculated Field Formula
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.