Forum Discussion
Solved
Freeze Excel formula when criteria met
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" Colu...
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
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
IF "date of arrival" column >0 then, date arrival - G2 else TODAY()-G2