I currently have the following function calculating:

=IF(OR(AA7="",AD7<""),"",TODAY()-(AA7+65))

AA7 and AD7 are date columns. The column they calculate in is AC7. So if
AA7 is zero then AC7 is zero. If AA7 has a date then AC7 should equal
AA7+65-the current date. But if AD7 has a date then AC7 should equal AD7-AA7
instead of calculating from the first portion.

With the current function its only placing a zero when AD7 has a date. How
can I modify the current function so that I also calculates correctly??