Outbacker wrote:
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

Just type the difference. For example in C2 you will have:

=B2- A2

If you don't need current time, my suggestion is to use TODAY() instead of
NOW().

Remember to format column C as General or as Number because Excel will
format as Date...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy