I have an excel spreadsheet with two columns with dates. I would like to set
a formula to see how many days in-between the two dates. Can this be done?

--
A

Candy

use the undocumented DATEDIF function. You can find detail here
http://www.cpearson.com/excel/datedif.htm

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"Candy" wrote in message
...
I have an excel spreadsheet with two columns with dates. I would like to
set
a formula to see how many days in-between the two dates. Can this be done?

--
A

If one column is A and the other column is B, it might be as simple as
=A1-B1

But that can be misleading: you may need to adjust by adding 1 to the
formula, such as
=A1-B1+1
This depends on your desired outcome. If the two dates are May 5 and
May 1, is the correct answer "4", i.e., 5-1, or is it 5 (day 1 + day 2
+ day 3 + day 4 + day 5)?

On top of all that, to get a positive answer, the earlier date must be
subtracted from the later date. If the later date always appears in
column A, A1-B1 will work; if the earlier date always appears in
column A, B1-A1 will work. If the dates can appear in either column,
use
=ABS(A1-B1)
....which returns a positive answer regardless, using the Absolute
value function.

Dave O