=B2-A2

and format as general

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Outbacker" wrote in message
...
i have a long conditional IF formula that results in different dates in a
specific column. the next column has todays date as =NOW().
my question is how can i write a formula to subtract the date that results
from the formula.
the formula date range is in column a.
the current date is in column b.
id like the results in column c.
thanks in advance