Formula to calculate how many days

[Vickie]

I need a formula that would subtract one date from another
to give me the number of days in between. For example:
10/2/2003 - 10/15/2003 = 13. Any ideas??

Bless you!
Vickie

 

[Don Guillett]

Excel calculates each day as one. Figure it out.

 

[Gerry Kuta]

=DATEDIF(A1,A2,"d")

 

[Ron Rosenfeld]

=DATEDIF(A1,A2,"d")

No need for DATEDIF here:

=A2-A1


--ron