Status Change based on dates

[nniphadk]

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 cases

	Start Date	End Date	Start Date	End Date	Start Date	End Date	Contract Status
Jane Doe	3/26/2015	12/31/2026	8/27/2021	12/31/2024	1/5/2022	1/5/2023	Active
John Doe	5/14/2012	9/30/2019	8/1/2017	8/26/2020	10/1/2019	10/1/2022	Expired

The contract status can be one of these choices: ACTIVE OR EXPIRED

[#2]

@nniphadk I don't think you finished your post. What is your question, what outcome are you expecting and what have you tried so far?

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#3]

@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.