Nested IF Function

Yes!!! That helped but now some of the dates it is giving are not right. Basically I am trying to get the greatest date. If an employee was hired but not termed that date should be the greatest of hire retention date or today plus one year ($Q$1). If the employee was termed, it should be the greatest of hire retention date or term retention date. If he was rehired, greatest of rehire retention and $Q$1. If retermed, the greatest of rehire retention and reterm retention.  It is still not giving me that on all rows.

It is giving me the correct dates if there has been at least one termination date and one rehire date. If there is no termination or rehire date the formula for enter the greatest of hire date and today plus one year is not coming out right.  It is only giving me 1/0/1900. I didn't change anything more than adding the parenthesis you suggested.