If there is no info in the second date column leave the formula cell empty or say "incomplete"
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?
Tags:
Best Answer
-
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"))
Answers
-
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"))
-
Perfect thanks so much :)
