days between dates in a column

[dataman]

I have a column (A) of dates and want the number of days from date to
date to appear in the next column (B).

 

[Chip Pearson]

You can simply subtract one date from another to get the number
of days between the two.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peo Sjoblom]

In B2

=A3-A2

format as general and copy down


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



-

 

[dataman]

I have done that but I get a negative number

 

[dataman]

yep that worked! I failed to reformat the column to number.
Thanks!