is it possible if i write at J5=clear, I5 will stop updating difference of dates?Capture.PNG
is it possible if i write at J5=clear, I5 will stop updating difference of dates?Capture.PNG
welcome to the forum. so what are you hoping to see in cell I5 instead. try to upload a sample excel file showing that next time. if you wish to show a blank, maybe:
=IF(J5="clear","",DATEDIF(H5,TODAY(),"d"))
but since you are looking for difference in days, there's a simpler way instead of DATEDIF. simply:
=IF(J5="clear","",TODAY()-H5)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You can do it with an intentional circular reference.
In I5
=IF(J5="clear",I5,TODAY()-H5)
Remember to 'Enable iterative calculation' before entering the formula. Also, you need to enter the formula before entering 'Clear' into the status column.
If you don't set it up in the correct order then it will not work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks