Custom Dates between 4 dates columns

[RMRaptor]

Hello All

we have scenario  we have 4 date columns , we want to know if Purchase date and Shipping falls between Order date and sales date, if it does then insert value of Purchase date. is it possible to achieve this calculations or can we break it nested if else statement.?

Product A 

PurchaseDate :03/01/2023 

ShippingDate: 05/10/2023

Product B 

PurchaseDate :05/12/2023 

ShippingDate: 07/28/2023

Product C

PurchaseDate :08/01/2023 

ShippingDate: 11/30/2023

OrderDate: 03/01/2023

Sales Date: 09/16/2023

[Ahmedx]

show what your table looks like