If there is no info in the second date column leave the formula cell empty or say "incomplete"

Chris_Lloyd

I can either get the calculation to work or I can get it to say Incomplete when the second date is empty. How do I get it to do both?

Carson Penticuff

I think this will do what you are looking for:

=IF(ISDATE([ASSMT DATE]@row), IF(ISDATE([AUTH'D DATE]@row), [AUTH'D DATE]@row - [ASSMT DATE]@row, "Incomplete"))

Carson Penticuff

I think this will do what you are looking for:

=IF(ISDATE([ASSMT DATE]@row), IF(ISDATE([AUTH'D DATE]@row), [AUTH'D DATE]@row - [ASSMT DATE]@row, "Incomplete"))

Chris_Lloyd

Perfect thanks so much :)