since you are concerned about days
=b1-a1 will work

I find that datedif is more efficient when dealing with months or years....
--
Wag more, bark less


"Justin" wrote:

I just want to be able to count days between two dates. I am using excel 2003.

example
a1 12/5/1999 b1 03/04/2007
if i want the number of days between a1 and b1 in c1, what should the
formula read? What format should each of the cells be in?