subtracting two dates issue

[Guest]

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

 

[Franz Verga]

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

 

[Bob Phillips]

=B2-A2

and format as general

--
HTH

Bob Phillips

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