Duration Report End and Keep the value

Hi I have a simple formula:Today()-[B2C Start Date] calculating for a Duration Field. However once the person discharges, I would like the duration report to stop counting and retain the value when the [B2C Discharge Date] is entered.Is there a way to do this?Thank you!Katie

IT WORKS!!!! I love trying to figure this stuff out-but you just saved me a bunch of work-I promise to keep learning-but thank you in the meantime!!!!So exciting and cool that you can speak in this "language"Cheers!!!!