Excel function counting days until other cell changes

Question

Is there any function count days until other cell changes.

Example The order has been issued at 22 dec, 2022. It will start to count the days until the other cell has string “approved”.

I tried Today()-22 dec, 2022. But how can I stop this function if the other cell changed to what I demand and I want to hold the number of days.

Answer 1

You could try the following

if(a2='approved',"",Today()-a2)