C1: =B1-A1
Where C1 is where you wan the difference to show, A1 is the earlier date,
and B1 is the later date. If you don't know necessarily which one will be
later, you could do the following:
C1: =ABS(A1-B1)
Ensure, in either case, cell C1 is formatted as General or a number.
If the two dates are in cells A1 and B1 then put the following formula
in cell C1:
=B1-A1
Format cell C1 as number.
Hope this helps / Lars-Åke
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.