What value should be returned if the field is empty?
Just guessing here, but maybe this would work:
Min ( Date complete-Life Cycle date in ; Get ( CurrentDate ) -Life Cycle date in )
This computes the elapsed days to the date complete if it exists and the elapsed days to the current date if it does not exist.
Thank you for your response. If the Date Complete field is empty then the Days in Life Cycle field should be blank.
If ( Date Complete ; Date complete-Life Cycle date in )
Thanks! So simple - I was overthinking it!