Try somehting like this:

=IF(B2,B2,TODAY())-A2

Or, for something more robust:

=IF(COUNT(A2),IF(ISNUMBER(B2),B2,TODAY())-A2,"")

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


"Amatuer" wrote in message
...
I'm sure this is basic for most of you but it is baffling me:

I need a formula to subtract date column 1 from date column 2 (that part I
have) AND IF there is NOT a date in date column 2, subtract date column 1
from TODAY's date. Thanks!