Hi,

Try this =if(AA7="","",TODAY()-(AA7+65),if(AD7="","",(AD7-AA7)))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"akemeny" wrote in message
...
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??