SOLVED

Freeze Excel formula when criteria met

Occasional Contributor

Hello Guys

 

Might be easy but i have a headache here 

 

Preface

I want the "Days in transit" Colum to stop updating the formula when I select the Yes answer in the "Arrived at destination" Colum currently the formula on "Days in transit" is "=TODAY()-G2"

 

Screenshot 2022-12-21 143811.png

 

i have tried =IF(L3="yes","","=TODAY()-G2") 

 

but i don't think the formula is correct 

 

I'm out of ideas 

 

 

5 Replies

@simon_70 

=IF(L2="yes","",TODAY()-G2)

 

Maybe like this.

 

 

 

@Quadruple_Pawn 

@Riny_van_Eekelen 

 

thank you that helped

Now I just need it to stop counting when yes is selected in "Arrived at destination" 

 

the no logic is working correctly so its something i need to put in the middle i believe 

 

=IF(L3="yes","__not sure  what to put here__",TODAY()-G3)

If possible please update date of arrival in column and rephrase the formula as below
IF "date of arrival" column >0 then, date arrival - G2 else TODAY()-G2
best response confirmed by simon_70 (Occasional Contributor)
Solution

@simon_70 

Instead of No/Yes in the Arrived at destination column, I'd leave it blank initially, and enter the date of arrival when the item has arrived. You can then use

 

=IF(L2="",TODAY(),L2)-G2

hey this worked thank you all