formula to show days between dates in a whole number?

[matt]

i am trying to set a formula up that will show days(whole number) between two
dates. i.e. 11/4/04 through 11/5/04 = 1 day.

 

[JulieD]

Hi Matt

use the DataDif function
=datedif(starting date, ending date, "d")

check out Chip Pearson's website for more details
http://www.cpearson.com/excel/datedif.htm

Cheers
JulieD

 

[Frank Kabel]

Hi
=A2-A1
and format as number