multiple if conditions in a formula tool

Question

I want help in achieving the below conditions. can someone please help I have attached the conditions

Conditions.xlsx

atcodedog05 · Answer

Hi @Lumjing

Here is my take

Hope this helps : )

Completed date (1).yxmd

Lumjing · Answer

@atcodedog05 and @binu_acs

sorry but I spend some time working on getting the results for attached input but not getting it can you please help.  have attached the data

Start date                           End date                  Final
Not Applicable                   9/2/2022                   9/2/2022
11/3/2022                          Not Applicable          11/3/2022
Null                                   Null                            Null
11/3/2022                          9/2/2022                  11/3/2022
8/12/2022                          9/2/2022                  9/2/2022
Not Applicable                                                   Null
                                      Not Applicable             Null

Start dateEnd dateFinalNot Applicable9/2/20229/2/202211/3/2022Not Applicable11/3/2022   11/3/20229/2/202211/3/20228/12/20229/2/20229/2/2022Not Applicable   Not Applicable 11/6/2022

Conditions.xlsx

atcodedog05 · Answer

Hi @Lumjing

You can reduce the formula to like below which will have the same functionality.

Workflow:

Hope this helps : )

Completed date.yxmd