Can I get some assistance with a date calculation. I have a field called open and a field called closed. I have the 3rd field called days open. I currently have a calculation
closed - open
This give me a number if I have a closed date. Where I need help is if I do not have a closed date yet, what would the calc be to still give me the days open and when I put a closed date in, it stops counting.
I appreciate any help.