Datedif pause?

[ExcelBeginner85]

Hi All,
I have a =datedif formula in my worksheet in column D and in column E I have a status of open, I need to be able to have the datedif count down or up with a status of open but when I enter a status of closed in column E I need the datedif in Column D to pause/stop so I can see how many days have passed, is this possible as I am very new to excel and still struggling to get to grips with it. Thank you

[martindwilson]

i tax it you are using today() in the datedif() formula. so it will always recalculate
without code the easiest way would be to put a date in say col f when closed then use that instead
something like

=DATEDIF(Date1,if(e2="closed",f2,today()),"m")