Hi the community.
I have some difficulties with a formla.
I deliver package and i want to calcul the date of the preparation in relation to the delivery date decided by the customer
I want to calcul a date but this is conditionate with the result of a column.
Column A, i have a date : 12/04/2021
Column B, i have two type on result : “GLS” or “Chronopost”
This is what i want is :
If GLS = Date of the column A - 2 day.
With my example the result : 10/04/2021
If Chronopost = Date of the column A - 1 day.
With my example the result : 11/04/2021
Sorry for my english.
Could you help me please ?
Thank’s a lot,
Matthieu from www.lagreentouch.fr